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. Select Connectors in the top left corner of the page.

3. Click on your chosen connector.

4. Select the Schema tab.

5. Search for your chosen table.

6. Move your cursor to the far right of the table name. A re-sync button will appear.

   

7. Click Resync.

8. Confirm by clicking 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.