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 warehouseUSAGE
privilege on target databaseUSAGE
privilege on target schemaSELECT
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 :
- JDBC connection string
- login
- password
Alternative authentication method
Above connection was performed using basic authentication.
Snowflake offers more elaborated ways of authentication.