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.