Standard

. Accumulate the changes in a single apply cycle and intelligently merge them into fewer SQL statements before applying them to the target. For example, if an update followed by a delete occurs on the source row, no row is applied to the target. If multiple updates occur on the same column or field, only the last update is applied to the target. If multiple updates occur on different columns or fields, the updates are merged into a single update record before being applied to the target.

Soft Delete

. Apply source delete operations to the target as soft deletes. A soft delete marks the deleted row as deleted without actually removing it from the database. For example, a delete on the source results in a change record on the target with "D" displayed in the INFA_OPERATION_TYPE column. If an update followed by a delete occurs on the source, two records are written to the target both with "D" displayed in the INFA_OPERATION_TYPE column.

Audit

. For Snowflake targets only, ingest change data into an audit table on the target system by using insert operations, instead of merging and applying the changes to the target database. Consider using audit tables if you want to perform computations or other downstream processing on the data before applying it to the target database or if you want to examine the changes. You can add metadata columns for SQL change operations to the audit table by setting options under the

Advanced

section.