ODBC Connector > Pushdown optimization > Pushdown optimization transformations
  

Pushdown optimization transformations

When you configure pushdown optimization, the Secure Agent tries to push the configured transformation to the database.
The following table shows the supported pushdown types for each database to which you can push the transformation:
Transformations
Amazon Redshift
Google BigQuery
Microsoft Azure SQL Data Warehouse
Netezza
PostgreSQL
Snowflake
Teradata
Aggregator
Source, Full
Source, Full
Full
Source, Full
Source, Full
Source, Full
Source, Full
Expression
Source, Full
Source, Full
Full
Source, Full
Source, Full
Source, Full
Source, Full
Filter
Source, Full
Source, Full
Full
Source, Full
Source, Full
Source, Full
Source, Full
Joiner
Source, Full
Source, Full
Full
Source, Full
Source, Full
Source, Full
Source, Full
Lookup
Source, Full
Note: Also supports unconnected lookup transformation.
Source, Full
-
-
Source, Full
Source, Full
Note: Also supports unconnected lookup transformation.
-
Sorter
Source, Full
Source, Full
Full
Source, Full
Source, Full
Source, Full
Source, Full
Union
Source, Full
Source, Full
Full
Source, Full
Source, Full
Source, Full
Source, Full
Router
Full
Full
Full
Full
-
Full
Full
Update Strategy
-
Source, Full
-
-
-
-
-
Sequence Generator
-
-
-
-
-
Source, Full3
-
1 See the limitations for configuring a Lookup transformation for Redshift in the "Rules and guidelines for pushdown optimization" topic.

2 See the limitations for configuring a Lookup transformation for Snowflake in the "Rules and guidelines for pushdown optimization" topic.

3 See the limitations for configuring a Sequence Generator transformation for Snowflake in the "Rules and guidelines topic for pushdown optimization" topic.