Configuring pushdown optimization for Snowflake using the ODBC Connector

Back Next

Create a Snowflake ODBC connection

Create an ODBC connection to connect to Snowflake after you configure the Snowflake ODBC drivers.

Perform the following steps to create a Snowflake ODBC connection on the

Connections

page:

In Administrator, click

Connections

The Connections page appears.

Click

New Connection

The

New Connection

page appears. The following image shows the New Connection page:

Configure the following connection details in the

Connection Details

section:

Property	Description
Connection Name	Name of the ODBC connection. For example, sf_odbc.
Description	Description of the connection.
Type	Type of the connection. Select the type of the connection as ODBC .

Configure the following connection details in the

ODBC Connection Properties

section:

Property	Description
Runtime Environment	Runtime environment that contains the Secure Agent you can use to access the system.
User Name	User name to log in to Snowflake.
Password	Password to log in to Snowflake.
Data Source Name	Enter the name of the ODBC data source name that you created for Snowflake.
Schema	Name of the Snowflake schema.
Code Page	The code page of the database server or flat file defined in the connection.
ODBC Subtype	Enter the value of the ODBC Subtype field as Snowflake .
Driver Manager for Linux	The driver that the Snowflake ODBC driver manager sends database calls to.