You can use an ODBC connection in a Snowflake mapping to enable cross-database SQL ELT optimization to run queries on data spread across multiple databases.
You can configure cross-database SQL ELT optimization in the mapping task. You must ensure that the source and target transformations in the mapping must use two different ODBC connections that point to different database DSN entries.
You can configure cross-database SQL ELT optimization for the following database when you use the ODBC connection:
•Snowflake
To configure cross-database SQL ELT optimization in a mapping configuration task, perform the following tasks:
1In the Runtime Options page of the mapping configuration task, navigate to the Advanced Session Properties section.
2Click Add to add a new session property.
3From the Session Property Name list, select Allow SQL ELT across Databases and set the Session Property Value to Yes.
For more information about configuring cross-database SQL ELT optimization to read from or write data to objects associated with different schemas within the same database and for examples, see the help for the relevant connector.