Skip to main content Skip to complementary 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 Snowflake ODBC driver 2.25.3 (64-bit) or later for Windows on the Qlik Replicate Server machine.

Qlik Replicate for Linux:

Download and install Snowflake ODBC driver 2.25.3 (64-bit) or later for Linux on the Qlik Replicate Server machine.

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.com/en/user-guide/data-load-azure-config.html

For information on signing up for a Microsoft Azure Blob Storage account, see the vendor's online help.

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.

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!