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.