Snowflake Data Cloud Connector > Part III: SQL ELT with Snowflake Data Cloud Connector > SQL ELT optimization for mapping tasks > Pushing logic to a database with different schemas
  

Pushing logic to a database with different schemas

You can use cross-schema SQL ELT 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 SQL ELT optimization, create two 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.

Configuring cross-schema SQL ELT optimization

To push processing logic for different schemas within a Snowflake database, configure cross-schema SQL ELT optimization in the mapping task.
    1Create a mapping task.
    1. aSelect the configured mapping.
    2. bIn the SQL ELT Optimization section on the Runtime Options tab, set the SQL ELT optimization value to Full.
    2To enable cross-schema SQL ELT optimization, select Enable cross-schema SQL ELT optimization.
    Default is enabled.
    3Save the task and click Finish.