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.
Table re-syncs are not available for all connectors. See the Features section within the connector’s Fivetran documentation to verify if the connector can be re-synced on a table level.
Select your chosen connector from your Fivetran dashboard.
Select the Schema tab.
Search for your chosen table.
Move your cursor to the far right of the table name. A re-sync button will appear.
Click the re-sync table button.
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. Also, table re-syncs do count towards MAR.