Skip to content

MergeInsertIntoTableRequest

Request for merging or inserting records into a table, excluding the Arrow IPC stream.

Properties

Name Type Description Notes
id List<String> [optional]
on String Column name to use for matching rows (required) [optional]
whenMatchedUpdateAll Boolean Update all columns when rows match [optional]
whenMatchedUpdateAllFilt String The row is updated (similar to UpdateAll) only for rows where the SQL expression evaluates to true [optional]
whenNotMatchedInsertAll Boolean Insert all columns when rows don't match [optional]
whenNotMatchedBySourceDelete Boolean Delete all rows from target table that don't match a row in the source table [optional]
whenNotMatchedBySourceDeleteFilt String Delete rows from the target table if there is no match AND the SQL expression evaluates to true [optional]