Source settings
Controller task scheduling period.
This task for example executes delta based merge.
Backup retention period: Retention period for backups created after table deactivation (in days).
Cleanup staging tables: Turn on/off of staging tables.
Stage table data retention period: Retention period for already merged data in staging table.
Backup retention for Statistics: For how long statistics are being kept.
Merge settings
Warehouse: What warehouse should be used for merge execution.
Suffixes for merge objects. Resulting name for the merge object is <Staging table name>+<suffix>. It can be defined for following objects:
Merge table
Merge view
Merge stream
Merge task
Use custom schema for merge objects: Generate merge objects in their respective schema instead of the staging table schema. Defined schema cannot exist as a source schema or be defined for another source schema. It can be defined for following objects:
Merge table
Merge view
Merge stream
Merge task
Merge scheduling period: How often merge should run on replicated tables.
Delete type:
Soft - Keep deleted entries in the merge table with delete flag.
Hard - Do not transfer deleted entries into merge table.
Display soft deletes in merge view: Display entries with delete flag in merge view.
Delta-size based merge: Use stream row count as a trigger for merge.
Delta size to trigger merge: Stream row count needed to trigger merge.
Metadata settings
Timestamp field: Name of the field used to determine the last record of a specific key.
Change field: Type of change of specific field.
Insert flag: What identifier in metadata should represent inserts, can insert multiple values if they are separated by a comma, use the '<empty>' placeholder for space.
Update flag: What identifier in metadata should represent updates, can insert multiple values if they are separated by a comma, use the '<empty>' placeholder for space.
Delete flag: What identifier in metadata should represent deletes, can insert multiple values if they are separated by a comma.