When you create a mapping in SQL ELT mode, you choose the target connection first. The target connection must be a Snowflake Data Cloud connection.

You change the target connection in the mapping properties. In the Target transformation, the target connection is read-only.

If you add multiple targets to the mapping, all targets must use the same target connection or connection parameter. If you change the target connection, the Mapping Designer updates all targets in the mapping to use the new connection.