Issue

After triggering an initial historical sync or historical resync, the connector takes 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

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.

Note: Some connectors' cursors cannot be changed due to how their date range is stored. Please check with the Support team for more information.

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.