A condition to control if matched records are deleted. If no condition is given, *no* records are delete.
A condition to control if matched records are updated. If no condition is given all matched records are updated (default). Note that delete is applied before update. Records selected for deletion are automatically excluded from the updates.
List of column names to update in update clause. If empty all columns (except primary keys) are updated (default)
A condition to control if unmatched records are inserted. If no condition is given all unmatched records are inserted (default).
List of column names to ignore in insert clause. If empty all columns are inserted (default).
To optimize performance for SDLSaveMode.Merge it might be interesting to limit the records read from the existing table data, e.g. merge operation might use only the last 7 days.
To optimize performance for SDLSaveMode.Merge it might be interesting to limit the records read from the existing table data, e.g.
To optimize performance for SDLSaveMode.Merge it might be interesting to limit the records read from the existing table data, e.g. merge operation might use only the last 7 days.
A condition to control if matched records are deleted.
A condition to control if matched records are deleted. If no condition is given, *no* records are delete.
List of column names to ignore in insert clause.
List of column names to ignore in insert clause. If empty all columns are inserted (default).
A condition to control if unmatched records are inserted.
A condition to control if unmatched records are inserted. If no condition is given all unmatched records are inserted (default).
List of column names to update in update clause.
List of column names to update in update clause. If empty all columns (except primary keys) are updated (default)
A condition to control if matched records are updated.
A condition to control if matched records are updated. If no condition is given all matched records are updated (default). Note that delete is applied before update. Records selected for deletion are automatically excluded from the updates.
Options to control detailed behaviour of SaveMode.Merge. In Spark expressions use table alias 'existing' to reference columns of the existing table data, and table alias 'new' to reference columns of new data set.
A condition to control if matched records are deleted. If no condition is given, *no* records are delete.
A condition to control if matched records are updated. If no condition is given all matched records are updated (default). Note that delete is applied before update. Records selected for deletion are automatically excluded from the updates.
List of column names to update in update clause. If empty all columns (except primary keys) are updated (default)
A condition to control if unmatched records are inserted. If no condition is given all unmatched records are inserted (default).
List of column names to ignore in insert clause. If empty all columns are inserted (default).
To optimize performance for SDLSaveMode.Merge it might be interesting to limit the records read from the existing table data, e.g. merge operation might use only the last 7 days.