MatchActions

Use Skip to prevent overwriting or updating existing records in the target table.

• The export operation for the matching record is skipped.
• No columns are updated or inserted for that record.
• This is useful when you want to ensure only new data is added, and existing data remains unchanged.

Use Update to synchronize or refresh data in the target table.

• The mapped columns (except those in 'Match Columns' and 'Return Values') are updated in the existing row.
• No new row is inserted for the matching record.
• This is useful for keeping the database up-to-date with the latest extracted values, such as updating status or address fields.

Use Error to enforce strict uniqueness and catch unexpected duplicates.

• The export process stops immediately if a duplicate is detected.
• No changes are made for the matching record.
• This is useful for data quality enforcement, or when duplicates indicate a configuration or extraction issue.