When you configure a Target transformation in a mapping in SQL ELT mode, you need to use only a Snowflake Data Cloud connection.
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.