PowerExchange for Snowflake User Guide

10.5.6
- 10.5.4
- 10.5
- 10.4.1
- 10.4.0

Back Next

Create a Snowflake ODBC Connection

Create a Snowflake ODBC connection to access Snowflake source and target objects.

In the Developer Client, click

New Connections

The

Select a Connection Category

box appears.

Select

Connections

Database

ODBC

Create a new Snowflake ODBC connection.

Specify the name, description, and location for the connection.

Select the

Type

Database/ODBC

and click

Configure the following connection properties:

Connection Property	Description
User Name	The user name to connect to Snowflake.
Password	The password to connect to Snowflake.
Pass Through Security Enabled	Enables pass-through security for the connection. When you enable pass-through security for a connection, the domain uses the client user name and password to log into the corresponding database, instead of the credentials defined in the connection object.
Connection String	The name of the ODBC data source that you created for Snowflake on the Data Integration Service host machine. For example: Snowflake_ODBC_SERVER
Code Page	The code page that the Data Integration Service uses to read or write data.
Environment SQL	SQL commands to set the database environment when you connect to the database. The Data Integration Service runs the connection environment SQL each time it connects to the database.
Transaction SQL	SQL commands to set the database environment when you connect to the database. The Data Integration Service runs the transaction environment SQL at the beginning of each transaction.
SQL Identifier Character	The type of character used to identify special characters and reserved SQL keywords, such as WHERE.
Support Mixed-Case Identifiers	When enabled, the Data Integration Service places identifier characters around table, view, schema, synonym, and column names when generating and executing SQL against these objects in the connection.
ODBC Provider	The type of database to which ODBC connects to perform pushdown optimization. Select the ODBC provider as Snowflake to enable the Integration Service to generate native database SQL.