You can translate the question and the replies:

Create Base Views only from certain Snowflake databases

Hello, I used the Snowflake JDBC 3.13.1 Driver to connect to Snowflake from Denodo. When creating the data source i filled in values for the database, the chema and the warehouse in the Database URI (this is the pattern for the URI : jdbc:snowflake://host/?db=database&schema=schema&warehouse=warehouse). When creating a base view out of this Snowflake data source I am able to select ALL the databases that are available with my Snowflake account and not just the one I filled in as "database" value in the URI when I created the datasource. Is it possible to "hide" the other Snowflake databases in Denodo and to only give me access to the database I selected in the URI ? If it is not possible then why is it necessary to fill in this information in the URI? Thanks in advance.
snowflake database base view restriction
user
06-02-2023 04:41:45 -0500
code

1 Answer

Hi, The JDBC driver provided by Snowflake in order to connect with Denodo, requires a database name parameter in the URI connection. This parameter marks the default database to use once connected, but the connection created, provides access to all the data in Snowflake for which the user has permissions. https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Snowflake%20from%20Denodo If you want to restrict the creation of base views for other databases, besides the one that is in the URI, an option is to create a new user with limited privileges. Hope this helps!
Denodo Team
06-02-2023 09:48:15 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here