Skip to main content

Connect to Snowflake

DirectQuery Snowflake connector is using Snowflake JDBC driver to connect to a database.

User and Role​

To connect DirectQuery to Snowflake, you will first need a User linked to a Role with sufficient privileges.
You can perform these following actions with a Snowflake 'power user' account.

Create a Role​

This reference can help you to create a Role.

Grant required privileges to this Role​

DirectQuery required privileges are :

  • USAGE privilege on target warehouse
  • USAGE privilege on target database
  • USAGE privilege on target schema
  • SELECT privilege on schema queryable objects (tables, views)

This reference will help you to grant these to your new role.

Create a User linked to this Role​

Last step is to create a User with the following attributes :

  • login
  • password
  • default role (the role you have just created)
  • default warehouse (warehouse which will be used to run the queries)
  • default namespace (YOUR_DATABASE.SCHEMA)

For more help on this step you may refer to user management help section.

Basic authentication connection​

Connection is done through DirectQuery Snowflake connector passing the minimal following properties :

Alternative authentication method​

Above connection was performed using basic authentication.
Snowflake offers more elaborated ways of authentication.