Badger Data - Configuring an ODBC Connection (Windows)

When connecting to Badger Data, some applications may require you to create an ODBC connection to Snowflake rather than using a native driver. This document goes through the steps to configure an ODBC connection for Badger Data on Windows operating systems.

  1. Download and install the appropriate ODBC driver from Snowflake.

  2. Open ODBC Data Sources with the same bit version you installed.

    start menu odbc data sources

  3. Under User DSN, click Add.

    ODBC Data Source Administration dialog box showing Add button highlighted

  4. Locate SnowflakeDSIIDriver in the list and click Finish.

    Create New Data Source dialog screen with SnowflakeDSIIDriver highlighted

  5. A new dialog window will open. Fill in the dialog using the information below.

    Snowflake Configuration Dialog showing information populated for Data Source, User, Server, Warehouse, Tracing, and Authenticator.

    • Data Source: Any name (e.g., BADGER_DATA)

      While you can have spaces in the data source name, other program using the ODBC connection may not be able to take in space characters. Use caution when configuring connections with space characters in the name.

    • User: <Your NetID>@wisc.edu (e.g., bbadger@wisc.edu).  
      In the example pictured above, replace YourNetId@wisc.edu with your actual NetId email address.

    • Server: laa66896.us-east-1.snowflakecomputing.com

    • Warehouse: BA_USER_SM

    • Tracing (0-6): 4

    • Authenticator: externalbrowser