Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Fully qualify the Tables in Datasets created using snowflake connector

Needs Votes
1
Views
0
Comments

Hello,

For datasets that are created using snowflake connector,

  1. Even after specifying a database in the connection, the dataset lists all the schemas that the user has access to. the scheamas that are under a different database is also listed in the same list
  2. The schemas are not fully qualified, so user can not differentiate between which schema is under which database. if there are mutiple schemas with same name in different databases, it is not possible to recognize which schema is form which database
  3. the connection properties does not have a way to specify the role the connection should use. it uses a default role of the user, which is not always desired role
  4. The schema list includes the snowflake system schemas TPCH_SF1, TPCH_SF10 etc that should never be used or required for anlaytics.
1
1 votes

Needs Votes · Last Updated

Welcome!

It looks like you're new here. Sign in or register to get started.