Snowflake Cloud Data Warehouse V2 Connector > Snowflake pushdown optimization > Snowflake pushdown optimization overview

Snowflake pushdown optimization overview

You can use pushdown optimization to push the transformation logic to the Snowflake database.
When you run a task configured for pushdown optimization, the task converts the transformation logic to an SQL query or a Snowflake command. The task sends the query to the database, and the database runs the query. The amount of transformation logic that the Secure Agent pushes to the database depends on the database, the transformation logic, and the mapping configuration. The Secure Agent processes all transformation logic that it cannot push to a database.
You can configure pushdown optimization for a mapping in the tasks properties.