Snowflake Connector Guide

Snowflake Connector Guide

Configuring a Snowflake ODBC Connection on Linux

Configuring a Snowflake ODBC Connection on Linux

Before you establish an ODBC connection to connect to Snowflake on Linux, you must configure the ODBC connection.
Perform the following steps to configure an ODBC connection on Linux:
  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. Configure the odbc.ini file properties in the following format:
    [ODBC Data Sources]
    driver_name=dsn_name
    
    [dsn_name]
    Driver=path/driver_file
    
    Description=
    Server=domain_name
    role=role
    
  4. Specify the following properties in the odbc.ini file:
    Property Description
    ODBC Data Sources Name of the data source.
    Driver Location of the Snowflake ODBC driver file.
    Description Description of the data source.
    Database Name of the Snowflake Cloud Data Warehouse database.
    Schema Name of the Snowflake Cloud Data Warehouse schema.
    Warehouse Name of the warehouse in Snowflake Cloud Data Warehouse.
    Server Domain name of your Snowflake account.
    Role The Snowflake role assigned to user.
    It is important to specify the database, schema, and warehouse properties in the ODBC data source name.
  5. Run the following command to export the odbc.ini file:
    Export ODBCINI=/<odbc.ini file path>/odbc.ini
  6. Restart the Secure Agent.
The Snowflake ODBC connection on Linux is configured successfully.
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 November 07, 2019


Explore Informatica Network