How to use the Data Exchange feature using ODBC to connect to a database in Snowflake?

FIRST CREATED ON 16 Jun 2026 I AUTHOR Emma Camacho

The Data Exchange feature in Mail & Deploy allow the export of the Execution Logs into a database that can then be loaded into a Qlik App or your BI platform of choice:

Enable the setting here:

Management Console > Settings > Data Exchange

See Data Exchange Settings to find the definition of the tables.

Run the following commands in your laptop to create the Key Pair (for more information, see https://docs.snowflake.com/en/user-guide/key-pair-auth#configuring-key-pair-authentication):

Private key

openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8 -nocrypt

Public key

openssl rsa -in rsa_key.p8 -pubout -out rsa_key.pub

In the Snowflake console, run the following SQL statement to assign the public key to the user that will be used to connect to the database:

ALTER USER example_user SET RSA_PUBLIC_KEY='MIIBIjANBgkqh...';

and set its timezone to match the timezone of the server running M&D. For M&D SaaS use UTC.

ALTER USER example_user SET TIMEZONE = 'UTC';

The account connecting to snowflake only requires INSERT permissions to the three tables, however in order to run the TEST CONNECTION button you will need to temporarily grant SELECT permissions.

Please send us the rsa_key.p8 file and we'll save it in this folder with the exact same name C:\Mail & Deploy\PrivateKey\ .

Here is the example of our connection string to our Snowflake Data Exchange datasource

Driver={SnowflakeDSIIDriver};

Server=xxxxxx-dl00000.snowflakecomputing.com;

uid=MAD_SERVICE_DATAEXCHANGE;

AUTHENTICATOR=SNOWFLAKE_JWT;

PRIV_KEY_FILE=C:\Mail & Deploy\PrivateKey\rsa_key.p8;

PRIV_KEY_FILE_PWD=<password>; NOTE: required only if the Private Key file has a password

role=MAD_DATA_EXCHANGE_USER_ROLE;

database=MAD_DATAEXCHANGE_SAAS_INSTANCE;

SCHEMA=PUBLIC;

MAD_SERVICE_DATAEXCHANGE, MAD_DATA_EXCHANGE_USER_ROLE and MAD_DATAEXCHANGE_SAAS_INSTANCE are examples, you can name your user, role and database according to your naming convention.

Please contact us to get the IP address that should be whitelisted if this is required.

Find attached, a small example App in this article.

Looking for Additional Guidance?

If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.