Snowflake Connector Guide

Snowflake Connector Guide

Configuring a Snowflake ODBC Connection on Windows

Before you establish an ODBC connection to connect to Snowflake on Windows, you must configure the ODBC connection.
Perform the following steps to configure an ODBC connection on Windows:
  1. Download the Snowflake ODBC driver from your Snowflake account.
    You must download the Snowflake ODBC 64-bit driver.
  2. Install the Snowflake ODBC driver on the machine where the Secure Agent is installed.
  3. Open the folder in which ODBC data source file is installed.
  4. Run the odbcad32.exe file.
    The ODBC Data Source Administrator dialog box appears.
  5. Click System DSN.
    The System DSN tab appears. The following image shows the System DSN tab on the ODBC Data Source Administrator (64-bit) dialog box:
  6. Click Add.
    The Create New Data Source dialog appears. The following image shows the Create New Data Source dialog where you can select the Snowflake data source:
  7. Select the SnowflakeDSIIDriver and click Finish.
  8. Click Configure.
    The Snowflake Configuration Dialog appears. The following image shows the Snowflake Configuration Dialog where you can configure the connection properties:
  9. Specify the following connection properties:
    Property Description
    Data Source Name of the data source.
    User Username 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. You can specify the following values:
    • 0. Disable tracing.
    • 1. Fatal error tracing.
    • 2. Error tracing.
    • 3. Warning tracing.
    • 4. Info tracing.
    • 5. Debug tracing.
    • 6. Detailed tracing.
  10. Click OK.
The Snowflake ODBC connection is configured successfully on Windows.
After you configure the Snowflake ODBC connection, you must create an ODBC connection to connect to Snowflake. For more information about how to create an ODBC connection to connect to Snowflake, see Create an ODBC Connection.

Updated July 25, 2019


Explore Informatica Network