You can use pushdown optimization to push transformation logic to Snowflake source databases or target databases. Use pushdown optimization to improve task performance by using the database resources. When you run a task configured for pushdown optimization, the task converts the transformation logic to an SQL query. The task sends the query to the database, and the database executes the query.

You can use an ODBC connection to read from or write large amounts of data to Snowflake. Use source or full pushdown to enhance the performance.

To read data from and write data to a Snowflake object using the ODBC connection, perform the following steps:

Download and install the Snowflake ODBC driver.
Create a system DSN for Snowflake.
Import the Snowflake source and target objects.
Create an ODBC connection to access the Snowflake source and target objects.
Create and run a mapping.