Vishal Kumar on 03 Nov 2022 21:38:04
PBI Native Snowflake connector filters out internal schemas like INFORMATION_SCHEMA, currently. This behavior is inconsistent with Snowflake UI experience which shows this schema to connected user. The PBI ODBC connection to Snowflake shows all schemas for which access is in place, as well.
The user security at Snowflake end should govern the visibility rather than the tool one has used for connection.
Please let user decide if metadata schemas are to be seen or not.
- Comments (1)
RE: Snowflake connector - Internal schemas not visible
The Information Schema in Snowflake holds meta data that we wish to use to create data dictionary reports in order to help our developers and super users facilitate development of other reports and ETL processes.