When we are creating the DSN for ODBC connection to connect the Snowflake, First time we need to check that snowflake odbc driver install in our system or not. Without this driver we can’t create the DSN.
First
we need to install the Driver. Below is the official website to download the
driver.
https://sfc-repo.snowflakecomputing.com/odbc/win64/latest/index.html
After downloading the driver we need to install this.
Let’s create the DSN
Open ODBC Data Source Administrator and select User DSN and click on the Add button.
Select SnowflakeDSIIDriver
Click finish button
Here we need to provide all information. After filling all details click on the Test button.
Now click ok.
DSN Created successfully.
