Configuring pushdown optimization for Snowflake using the ODBC Connector

Back Next

Configure the Snowflake ODBC driver on Windows

Before you establish an ODBC connection to connect to Snowflake on Windows, configure the ODBC driver.

Download the Snowflake ODBC 64-bit driver from your Snowflake account.

Install the Snowflake ODBC driver on the machine where the Secure Agent is installed.

Open the folder in which ODBC data source file is installed.

Run the

odbcad32.exe

file.

The

ODBC Data Source Administrator

dialog box appears.

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:

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:

Select the

SnowflakeDSIIDriver

and click

Finish

Click

Configure

The Snowflake Configuration Dialog appears.

The following image shows the Snowflake Configuration Dialog where you can configure the connection properties:

Specify the following connection properties:

Property	Description
Data Source	Name of the data source.
User	User name to access Snowflake.
Password	Password to access Snowflake.
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.