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

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 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;
role=MAD_DATA_EXCHANGE_USER_ROLE;
database=MAD_DATAEXCHANGE_SAAS_INSTANCE;
SCHEMA=PUBLIC;

Find attached, a small example App in this article.


Info

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.