Qlik Replicate: ODBC connection string for Snowflake keypair authentication

SwathiPulagam — Wed, 22 Mar 2023 07:51:59 GMT

To connect to Snowflake using ODBC with keypair authentication, you can use the following connection string format:

Driver={SnowflakeDSIIDriver};Server=<account_name>.<region_name>.snowflakecomputing.com;User=<username>;PrivateKey=<path_to_private_key>;Db=<database_name>;Schema=<schema_name>

Each part of the connection string represents:

Driver: The ODBC driver name for Snowflake.
Server: The name of your Snowflake account with the region where your account is located (e.g. us-west-2).
User: Your Snowflake username.
PrivateKey: The path to the private key file on your local machine.
Db: The name of the Snowflake database you want to connect to.
Schema: The name of the Snowflake schema you want to use.

Note that you may also need to include additional connection parameters, such as Warehouse, Role, and SSL. Here's an example connection string that includes these parameters:

Driver={SnowflakeDSIIDriver};Server=<account_name>.<region_name>.snowflakecomputing.com;User=<username>;PrivateKey=<path_to_private_key>;Db=<database_name>;Schema=<schema_name>;Warehouse=<warehouse_name>;Role=<role_name>;SSL=on

Replace the placeholders in the connection string with the appropriate values for your Snowflake account and keypair authentication setup.

Environment

Snowflake Target

article Qlik Replicate: ODBC connection string for Snowflake keypair authentication in Official Support Articles

Qlik Replicate: ODBC connection string for Snowflake keypair authentication

Environment