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
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.