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.
aSelect the configured mapping.
bIn the SQL ELT Optimization section on the Runtime Options tab, set the SQL ELT optimization value to Full.
2To enable push down across databases, in the Advanced Options on the Runtime Options tab, select Allow SQL ELT across Databases as the Session Property Value and set the Session Property Value to Yes.