Are Incremental Syncs Blocked During a Table Re-Sync?
Question
When I trigger a table re-sync using the Fivetran REST API, do tables outside the re-sync scope continue syncing incrementally, or are they blocked until the re-sync completes?
Environment
Connector: PostgreSQL
Answer
Yes. Fivetran re-syncs only the selected tables or schemas and continues to incrementally sync tables outside the re-sync scope.
During the re-sync, we:
- Re-import the selected tables and pause their incremental progress until the re-sync completes.
- Continue to incrementally sync all tables outside the re-sync scope as scheduled.