You can configure cross-database pushdown optimization in the mapping task. You must ensure that the source and target transformations in the mapping must use two different ODBC connections that point to different database DSN entries.

You can configure cross-database pushdown optimization for the following database when you use the ODBC connection:

Snowflake

To configure cross-database pushdown optimization in a mapping configuration task, perform the following tasks:

On the

Schedule

tab of the mapping configuration task, navigate to the

Advanced Session Properties

section.

Click

Add

to add a new session property.

From the

Session Property Name

list, select

Allow Pushdown across Databases

and set the

Session Property Value

to

Yes

.

The following image shows the cross-database pushdown optimization configuration:

For more information about configuring cross-database pushdown optimization to read from or write data to objects associated with different schemas within the same database and for examples, see the help for the relevant connector.