When you configure a Target transformation in a mapping in SQL ELT mode, you need to use only a Databricks connection.
You can configure the following properties in a Databricks target transformation in a mapping in SQL ELT mode:
Target Type - Single Object, Parameter, Create New Target at Runtime
Operation - Insert, Update, Delete, Data Driven
Target Database Name
Target Table Name
Write Disposition - Append, Truncate
Update Mode - Update as Update, Update else Insert
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
ASK INFAPreview
