Snowflake Connector Guide

Snowflake Connector Guide

Configuring a Snowflake ODBC Connection

Configuring a Snowflake ODBC Connection

You can set the pushdown optimization for the ODBC connection type that uses Snowflake ODBC driver to enhance the mapping performance. To use an ODBC connection to connect to Snowflake, you must configure the ODBC connection.
After you create a Snowflake ODBC connection, add the Pushdown Optimization property under Advanced Session Properties tab when you create a mapping task and select Full or To Source in the Session Property Value field. You cannot configure target-side pushdown optimization by using Snowflake ODBC driver. To verify that the pushdown optimization has taken place, you can check the session log for the job. In Monitor, view the log for jobs.
Snowflake supports Snowflake ODBC drivers on Windows and Linux systems. You must install the Snowflake ODBC 64-bit driver based on your system requirement.

Updated August 12, 2019


Explore Informatica Network