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

Configuring pushdown optimization

To optimize a mapping, add the mapping to a task, and then configure pushdown optimization in themapping task.
    1. Create a mapping based on your requirement:
    2. Create a mapping task.
    1. a. Select the configured mapping.
    2. b. In the Pushdown Optimization section on the Schedule tab, set the pushdown optimization value to Full or To Source.
    3. c. Save the task and click Finish.
When you run the mapping task, the transformation logic is pushed to the configured database. To verify that the mapping was optimized, you can check the session log for the job. In Monitor, view the log for jobs.