Skip to main content

Prerequisites

The following section describes the prerequisites for using Snowflake on Azure as a Qlik Replicate target endpoint.

Client prerequisites

  • Qlik Replicate for Windows: Download and install Windows 64-bit ODBC driver 2.24.0 or later.

  • Qlik Replicate for Linux: Download and install Linux 64-bit ODBC driver 2.24.0 or later.

Performance and Cloud Services usage optimization

In order to optimize both Snowflake Cloud Services usage and overall performance, it is strongly recommended to enable the Apply batched changes to multiple tables concurrently option in the task settings' Change Processing Tuning tab.

For information about charges incurred when using Snowflake Cloud Services, see Snowflake: Additional Billing (Cloud Services Layer) Impact

Microsoft Azure Blob Storage prerequisites

You can configure the Snowflake on Azure endpoint to stage the data files on Snowflake (Windows and Linux) or on Azure Blob storage (Windows only). If you want to use Azure Blob storage, you need to sign up for a Microsoft Azure Blob Storage account and make a note of the account name, access key, container name, SAS token (Shared Access Signature), and target folder.

Note that the duration of the SAS token must be the same as the Replicate task duration. For an explanation of how to configure the SAS token, visit:

https://docs.Snowflake on Azure.net/manuals/user-guide/data-load-azure-config.html

For information on signing up for a Microsoft Azure Blob Storage account, visit:

How to get started with Snoflake on Azure

Microsoft Azure Blob Storage permissions

Qlik Replicate performs the following operations on the Azure Blob Storage container/folder:

  • On the Azure Blob Storage container: LIST and CREATE on SCHEMA public
  • On the Azure Blob Storage folder: READ, WRITE, and DELETE

Supported blob storage types

The following blob storage types are supported:

  • Standard storage with block blobs
  • Premium storage with block blobs only

Firewall prerequisites

Firewall port 443 needs to be opened for outbound communication.