Sync Modes

A sync mode dictates how Fivetran handles data changes - additions, updates, and deletes - when we sync data from your source to your destination. We offer two sync mode options, so you can choose whether your destination reflects the latest state of your source or preserves a full history of changes.

Sync mode options

You can choose the sync mode in the schema settings of your connection.

We offer the following sync modes:

Soft delete mode: Fivetran marks rows as deleted in the destination after they are deleted in the source. Each source row corresponds to one destination row, allowing you to quickly see its current state.
History mode: Fivetran records every version of your source row into the corresponding table in your destination. Each source row corresponds to multiple destination rows, allowing you to track its history over time.

Connector sync mode support

Soft delete mode is the default sync mode and is available for the vast majority of connectors. History mode is available only for certain connectors. To understand what sync modes your connector supports and whether you can switch between them, check the History mode row in the Features table on your connector's documentation page:

History mode row in Features table	What it means
No checkmark	The connector uses soft delete mode for all tables. History mode is not available.
Checkmark, Notes starts with "Selectable for"	You can switch between history mode and soft delete mode for the listed tables in your connection schema.
Checkmark, Notes says "All tables" or "All tables except…"	The connector uses history mode for all or most tables. You cannot switch to soft delete mode.
Checkmark, Notes lists specific tables (without "Selectable")	The listed tables are set to history mode by default and cannot be changed. All other tables use soft delete mode.