Summary
Snowflake ODBC Driver Installation, Configuration, Example & Microsoft Excel Data Loading
Snowflake ODBC Driver
How to Use Snowflake ODBC Driver is fairly a well known topic when it comes to BI tools like PowerBI or Tableau but bring data from snowflake to Microsoft Excel and also apply transformation is relatively less known topic. There are many analyst who are not familiar with any programming tools or BI tools and very good analysing data using Microsoft Excel and this article (hands on video guide in my youtube channel Data Engineering Simplified ) will help you to understand how snowflake ODBC driver works and how you can fetch data into your Microsoft Excel worksheet.
This blog and This blog (hands on video guide ) is a comprehensive & practical guide with hands-on exercise on snowflake ODBC driver. It explains the installation process to its usage in Microsoft Excel environment and will help you to answer the following questions
- How to setup snowflake ODBC driver?
- Configuration parameter to establish a snowflake ODBC connection?
- we need different snowflake ODBC driver version for different cloud provider?
- How to fetch snowflake data into Microsoft Excel sheet
- How to use power query using snowflake ODBC driver and transform data?
- How to configure snowflake ODBC driver in linux or Mac operating system?
- Which programming languages can use snowflake ODBC driver?
- How to download snowflake ODBC driver?
- Example of snowflake ODBC driver connection string?
- What is the latest version of snowflake ODBC driver?
The ODBC driver has different prerequisites depending on the platform where it is installed. For details, see the individual installation and configuration instructions for each platform.
Download Snowflake ODBC Driver
The installer for the Snowflake ODBC driver is distributed through the Snowflake Client Repository. Before downloading an updated version of the driver, you might want to first verify the version of the driver you are currently using.
Snowflake ODBC Driver Prerequisites
The ODBC driver has different prerequisites depending on the platform where it is installed. For details, see the individual installation and configuration instructions for each platform.
- Amazon Web Services: Version 2.17.5 (and higher)
- Google Cloud Platform: Version 2.21.5 (and higher)
- Microsoft Azure: Version 2.20.2 (and higher)
Snowflake ODBC Driver Installation on Windows
To establish an ODBC connection to connect to Snowflake on Windows, install the 64-bit Snowflake ODBC driver on the machine
- Download the 64-bit and 32-bit Snowflake ODBC drivers from the Snowflake web interface in your Snowflake account.
- Install the 64-bit Snowflake ODBC driver on the machine.
- Open the following directory where you installed the ODBC data source file:
- For 32-bit driver: C:\WINDOWS\syswow64
- For 64-bit driver: C:\WINDOWS\system32
- Once the installation is done,
- The ODBC Data Sources Administrator box appears.
- Click System DSN.
- The System DSN tab appears. The following image shows the System DSN tab on the ODBC Data Source Administrator box:
Click Add. The Create New Data Source dialog appears. The following image shows the Create New Data Source dialog box where you can select the Snowflake data source:
Select the SnowflakeDSIIDriver and click Finish. Click Configure. The Snowflake ODBC Driver DSN Setup box appears. Specify the following connection properties in the Connection Settings section:
| Data Source | Name of the data source. |
| User | User name to access the Snowflake database. |
| Password | Password to access the Snowflake database. |
| Server | Domain name of your Snowflake account. |
| Database | Name of the Snowflake database. |
| Schema | Name of the Snowflake schema. |
| Warehouse | Name of the Snowflake warehouse. |
| Role | The Snowflake role assigned to user. |
| Tracing (0-6) | Determines the amount of detail that appears in the log file. (0. Disable tracing.)(1. Fatal error tracing.)(2. Error tracing.),(3. Warning tracing.),(4. Info tracing.),(5. Debug tracing.),(6. Detailed tracing.), |
The following image shows the Snowflake ODBC Driver DSN Setup box where you can configure the connection settings:
