Issue

After triggering initial historical sync or historical re-sync, the connector is 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

Resolution

Resolution #1: 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.

Resolution #2: Adjust the historical sync date range 

Support has the ability to adjust the backward sync date range. The backward cursor can be set to stop at a specific year or to stop it from syncing any historical data.

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.