When you create a mapping in SQL ELT mode, you can read data from cloud data lakes and cloud data warehouses within the cloud ecosystem. Therefore, when you configure the source connection in the Source transformation, you can choose only an Amazon S3, Azure Data Lake Storage Gen2, or Snowflake Data Cloud connection.

If you add multiple sources to the mapping, all sources use the same source connection or connection parameter. If you change the source connection or connection parameter in one of the sources, the Mapping Designer updates the other sources so that they all use the same connection.

Mappings in SQL ELT mode that read data from a cloud data warehouse always write data to the same cloud data warehouse. Therefore, if the source is a Snowflake cloud data warehouse, it must use the same connection or connection parameter as the target.

When you create a connection parameter in the Source transformation, you can set the connection type to Amazon S3 or Azure Data Lake Storage Gen2. If you want to create a Snowflake connection parameter, you need to create the parameter in the mapping properties where you choose the target connection.

If you change the Snowflake connection in the mapping properties, the Snowflake connection in the source is automatically updated to use the same connection. If the Source transformation uses an Amazon S3 or Azure Data Lake Storage Gen2 connection, then the source connection doesn't change when you change the target connection.