How to Trigger a Historical Table Re-Sync

Question

A table re-sync lets you overwrite the data in a specific table, so that you can fix data integrity issues in selected tables without re-syncing the entire connector.

Just like re-syncing a connector, re-syncing a table pauses incremental updates until the sync completes. However, a table re-sync is much faster since single tables tend to have far less data.

Environment

Fivetran dashboard

Answer

Prerequisite

The connector must support table-level re-syncs. See the Features section within the connector's Fivetran documentation to verify if the connector can be re-synced on a table level.

Steps

1. Log in to your Fivetran dashboard.

2. On the left navigation menu, select Connections.

3. Select your chosen connection.

4. Select the Schema tab.

5. Search for the table you want to re-sync.

6. Click Re-sync corresponding to the table.

   

7. In the Re-sync Table pop-up window, click Start re-sync.

NOTE: Once your table begins a re-sync, your incremental sync may take a little longer than usual, because we are pulling in all historical data for that table.

NOTE: Manual re-syncs related to initial connector setup, debugging, and troubleshooting purposes count towards free MAR. This includes table-level and connector-level re-syncs and historical re-syncs initiated from the Fivetran dashboard or using our REST API. However, customers cannot trigger re-syncs to skirt their obligations under their signed Agreement with Fivetran. See Fivetran's pricing documentation for more details.