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

1. 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.

   

2. Find the table you want to sync in history mode, click its sync mode menu, and select History mode.

   

3. 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.

   

4. Click Submit changes.

Switch a table back to soft delete mode

1. Go to the Schema tab on your connector details page.

2. Find the table you want to sync in soft delete mode, click its sync mode menu, and select Soft Delete.

3. Click Save Changes in the top right corner. A pop-up window will open asking you to confirm your decision.

4. Select Drop unused history columns _fivetran_active _fivetran_start _fivetran_end if you want to drop these columns.

   NOTE: Dropping these columns will cause queries that use this table to break.

5. Click Submit Changes.

Limitations

For the following destinations, when switching from history mode to soft delete, we only retain active records, where _fivetran_active = TRUE, and delete all inactive records:

• Azure Data Lake Storage
• OneLake
• S3 Data Lake