Skip to main content Skip to complementary content

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 note

    Only 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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!