BI Validator's Data Compare test plan, to compare the report data with data from a SQL Query. Users can perform end-to-end validation of the data shown in the reports by comparing the report data with the data from the Source database or the Target database (e.g Snowflake) 

 

Assuming that you already have a BI Connection created, the next step is to create a DB Connection. This article provides the details of creating a DB Connection so that it can be used in the Data Compare test plan. 

 

Connecting to ODBC Data Source:

 

You can connect to any data source that support ODBC using the ODBC DSN option. Most of the data sources such MySQL, Hadoop, Redshift, Snowflake support ODBC DSN connection. Here, in this article, we will show you how to create an ODBC connection for Snowflake.


 

Step 1: To ensure that we get to the right page on Snowflake website,  search for "Snowflake  ODBC Connection" in Google.


 

 


 

Step 2: Select the "ODBC Driver - Snowflake Documentation" link. Please note that the URL may vary.


 

Step 3: Click on the link that has the latest version of the drivers.




Step 4: From the list, download the right driver for your Operating System



 

Step 5: Install the driver. Upon successful installation, you should see the driver in your ODBC Driver list. To view this, search for "ODBC Data Sources (64 Bit)" in your Windows Search (assuming Windows). 



 

Step 6: Next, click on the System DSN and click on "Add" to create ODBC DSN Entry for your Snowflake Data Source. 


 

 

Step 7: When you click on Add, a popup comes up where you can add Snowflake specific details as displayed below.



 

User: The name of the user for your Snowflake account.

Server: The name of your URL (e.g hc28499.snowflakecomputing.com). Your  URL could look different.

Warehouse: The name of your warehouse. You can get this name from the existing list under the "Warehouses" tab in your Snowflake account. 

Database: Select the name of the database from your existing list of Data warehouses in your  Snowflake "Databases" tab.

 


 

 

Step 8: Now in your BI Validator, create a new Database Connection.

 

Connection Name: Enter a connection name 

Database Type: Select a database type from the drop-down list (Pick here ODBC from drop down)

Username: Enter the name of the username based on your Snowflake account

Password: Enter the password for your account

DSN: Select the DSN which created earlier. (Refer Step:6)

Schema Name:  Enter schema name of DataSource

Test your connection by clicking on 'Test' You should see a "Connected Successfully' message.

Then click 'Save' to Save connection


 

Step 9: Verification


 

Verify the created snowflake DB connection. You should be able to see tables  of the connection. 

Now in your  BI Validator, enter the query and ensure that the query is run successfully.