Categories
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