History Mode Setup Guide Beta
For connectors where Fivetran just replicates the schema, you can choose which tables to sync in history mode and which to sync in soft delete mode. History mode syncs can add many rows to your database if the records change often, increasing Monthly Active Rows (MAR). Thus, you might want to activate history mode only for those tables whose historical data is analytically valuable to you.
To switch between history mode and soft delete mode, go to the Schema tab of your connector details page and switch the toggle.
Activate history mode for a table
Go to the Schema tab on your connector details page. If history mode is available for that connector, you will see the mode menu indicating either Soft delete or History sync mode when you hover over a table.
Find the table you want to sync in history mode, click its sync mode menu, and select History mode.
Click Save Changes in the top right corner. A pop-up window will open asking you to confirm your decision.
NOTE: If the connector is newly created and hasn’t synced any data yet, we won’t show this confirmation dialog box.
Click Submit changes.
Switch a table back to soft delete mode
Go to the Schema tab on your connector details page.
Find the table you want to sync in soft delete mode, click its sync mode menu, and select Soft Delete.
Click Save Changes in the top right corner. A pop-up window will open asking you to confirm your decision.
Select Drop unused history columns
_fivetran_active_fivetran_start_fivetran_endif you want to drop these columns.NOTE: Dropping these columns will cause queries that use this table to break.
Click Submit Changes.
Limitations
For some destinations, when switching from history mode to soft delete, we only retain active records, where _fivetran_active = TRUE. For such destinations, we delete all inactive records.
We support this behavior for the following destinations in Private Preview: