Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
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
vkm
Rank 5 - Community Champion
Hello,
For datasets that are created using snowflake connector,
- 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
- 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
- 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
- The schema list includes the snowflake system schemas TPCH_SF1, TPCH_SF10 etc that should never be used or required for anlaytics.
1