Question

Why after triggering initial historical sync or historical re-sync is the connector taking longer than expected to complete syncing? Subsequent incremental syncs are also taking longer than expected.

Environment

Check our documentation for an up to date list of connectors that have Priority-first Sync

Answer

For long incremental syncs: Allow historical sync to finish

Once the backward cursor has synced all data, incremental syncs will shorten in duration, as they will only be pulling the most recent data.

For shortening historical sync lengths: Adjust the historical sync date range 

Support has the ability to adjust the backward sync date range for most connectors*. This will stop the connector from syncing any historical data prior to the date set.

Cause

During the initial sync, Fivetran updates the destination with the most recent data. In each subsequent sync, we continue to update the most recent data first as part of forward sync, and then fetch historical data in small increments as part of backward sync.