You can use pushdown optimization to push transformation logic to 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.
This article explains how to set pushdown optimization for the ODBC connection type that uses Amazon ODBC Redshift drivers for Mapping Configuration tasks. This article also explains the supported pushdown optimization functions, operations, and rules and guidelines to use pushdown optimization.