Skip to main content
The Atoti DirectQuery Snowflake connector uses the Snowflake JDBC driver to connect to a database.

​
User and role

Connecting DirectQuery to Snowflake first requires a user linked to a role with sufficient privileges. The following actions require a Snowflake ‘power user’ account.

​
How to create a role

The Snowflake role creation reference describes how to create a role.

​
How to 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)
The Snowflake privilege granting reference describes how to grant these to the new role.

​
How to create a user linked to this role

The last step is to create a user with the following attributes:
  • login
  • password
  • default role (the newly created role)
  • default warehouse (warehouse which will be used to run the queries)
  • default namespace (YOUR_DATABASE.SCHEMA)
The Snowflake user management documentation covers this step.

​
Basic authentication connection

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

​
Alternative authentication method

The connection above uses basic authentication. Snowflake offers other authentication methods.