Snowflake Connector Guide

Snowflake Connector Guide

Cross-Schema Pushdown Optimization

Cross-Schema Pushdown Optimization

You can use cross-schema pushdown optimization for a mapping task to read from or write data to Snowflake objects associated with different schemas within the same Snowflake database.
To use cross-schema pushdown optimization, create two Snowflake ODBC connections and specify the schema in each connection. Ensure that the schema in the source connection is different from the schema in the target connection, but both the schemas must belong to the same database. When you configure pushdown optimization for the mapping task, enable cross-schema pushdown optimization in the advanced session properties. By default, the check box is selected.

Updated August 12, 2019


Explore Informatica Network