Skip to main content

Snowflake connection

Snowflake roles, warehouses, and privileges

The Snowflake user specified in the connection must have a default Warehouse set in Snowflake

All queries run against Snowflake with this connection will use this Warehouse for their compute power.

If the Snowflake user specified in the connection does not have a default Role set in Snowflake, the connection will use the Public role, which may limit privileges to access and query data.

If a default Role is set for the Snowflake user, that Role will be used by the connection.

In order to create a virtualized connection to a table or view, the user must have USAGE privileges on the database and schema and SELECT privileges on the table or view.

If a default database is specified in the connection modal, it must be specified using all UPPER CASE letters.