How to connect to a Snowflake instance to create a data quality control directly
In this example there there is a Snowflake data warehouse that you want to monitor with a Query in Exmon Data Governance.
Other uses for this could be to transfer the data automatically to a SQL Server database by using a Data Transfer package within Exmon.
Create a Data Provider
Exmon connects to Snowflake using the Snowflake ODBC driver. If you are using Exmon SaaS you will need to setup the Data Provider on the server running the Exmon Gateway.
Download and install the Snowflake ODBC driver from Snowflake: https://docs.snowflake.com/en/developer-guide/odbc/odbc-download
Configure the ODBC 64bit System DSN:
En either Exmon Gateway (for Exmon SaaS) or Exmon Desktop (for Exmon On-Prem), create a Data Provider, select ODBC as the Datasource Type and in the Connection String write:
DSN=NAME;PWD=%Password%
Under Authentication select Use Username and Password and enter your Snowflake password.
Then Save and Test Connection to verify.
Create controls using the Data Provider
Now the Snowflake data is available in Exmon, both from Queries and Data Transfers.