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

Pushing logic to different databases

You can enable cross-database SQL ELT optimization to run queries on data spread across multiple Snowflake databases.
You can configure cross-database SQL ELT optimization in the mapping task. Ensure that the Snowflake source and target transformations in the mapping uses two different Snowflake Data Cloud connections, or Snowflake ODBC connections.

Configuring cross-database SQL ELT optimization

To push processing logic across different Snowflake databases, configure cross-database SQL ELT optimization in the mapping task.
    1Create a mapping task.
    2Select the configured mapping.
    3On the Runtime Options tab, perform the following tasks:
    1. aIn the SQL ELT Optimization section , set the SQL ELT optimization value to Full.
    2. bIn the Advanced Session Properties section, add the Allow SQL ELT across Databases session property and enable the session property value.