ODBC Connector > Pushdown optimization > Rules and guidelines for pushdown optimization
  

Rules and guidelines for pushdown optimization

Certain rules and guidelines apply when you configure pushdown optimization to specific databases.

Amazon Redshift

Consider the following rules and guidelines for pushdown optimization to an Amazon Redshift database:

Google BigQuery

Consider the following rules and guidelines for pushdown optimization to a Google BigQuery database:

Microsoft Azure SQL Data Warehouse

Consider the following rules and guidelines for pushdown optimization to a Microsoft Azure SQL Data Warehouse database:

Netezza

Consider the following rules and guidelines for pushdown optimization to a Netezza database:

Teradata

You cannot use the upsert operation when you configure pushdown optimization with the Teradata ODBC connection.

Snowflake

Consider the following rules and guidelines for pushdown optimization to a Snowflake database:
Use the following rules and guidelines when you configure pushdown optimization to a Snowflake database:
Update override property
The update override property is applicable for all ODBC subtypes in the ODBC connection, except Snowflake.
Common fields in multiple sources
When you use a Snowflake ODBC connection in a mapping enabled with pushdown optimization to read data from two Snowflake sources that have fields with the same name and you define a filter condition for one of the common fields, the mapping fails.
Create Temporary View session property
Enable the Create Temporary View property in the session properties of the mapping task before you configure the following properties:
Not Null constraint
When you run a mapping to write data to a Snowflake target, and you define the primary key for the target table but do not explicitly define the Not Null constraint, the upsert, delete, or update operation fails. You must add the Not Null constraint for the target table and then run the upsert, delete, or update operation.
Sequence Generator transformation
When you configure a Sequence Generator transformation in a mapping, adhere to the following guidelines:
Lookup
When you configure a lookup, adhere to the following guidelines:
Create New at Runtime option
You can configure the Create New at Runtime option for a Target transformation in a mapping configured for pushdown optimization. When you use the Create New at Runtime option, adhere to the following guidelines:
Functions
When you push functions to Snowflake, adhere to the following guidelines: