You can add multiple targets to the mapping and view statistics for each target separately in the job details page, but all targets must use the same target connection or connection parameter.

You can configure the following properties in a Snowflake target transformation in a mapping in SQL ELT mode:

Target connection - Parameter, Allow parameter to be overridden at run time.
Target type - Single object, parameter.
Allow parameter to be overridden at run time.
Target object - Existing target, Create new at runtime.
Operation - Insert, update, delete, or data driven.
Update Columns
Update Mode
Database
Schema
Pre-SQL and Post-SQL
Truncate Target Table
Additional Write Runtime Parameters
Table name

The following target properties don't apply in a mapping in SQL ELT mode:

Warehouse
Role

For information on how the targets in mappings in SQL ELT mode behaves differently from the targets in other types of mappings, see Targets in mappings in SQL ELT mode in

Mappings

in the Data Integration help.