Prerequisites
Before you can use Snowflake as a data warehouse in a Qlik Compose project, make sure that the following prerequisites have been met:
Client
- Download and install Snowflake ODBC driver for Windows 2.18.1 or later.
- The Qlik Compose machine must be set to the correct time (UTC).
Permissions
The user specified in the Snowflake data warehouse settings must be associated with a role that grants the following privileges:
- USAGE on the Snowflake warehouse
- USAGE or OWNERSHIP on the specified database and its schemas
- SELECT on the INFORMATION_SCHEMA schemas
-
CREATE SCHEMA on the specified database.
Information noteOnly required for user-specified schemas that do not yet exist on the target.
- Tables:
- CREATE
- SELECT
- INSERT
- UPDATE
- DELETE
- TRUNCATE
- REFERENCES (for current and future tables)
- DROP (for user-initiated Drop and Create operations)
- Views:
- SELECT
- CREATE (for current and future views)
- DROP (for user-initiated Drop and Create operations)
- External functions called by user-defined ETLs:
- USAGE