Long-Running Syncs

Issue

A Salesforce connection is taking longer than usual to sync data.

Connector: Salesforce or Salesforce Sandbox

Several factors can contribute to longer sync duration:

Re-syncs: Search for the resync_table log event in your logs by either using our free Fivetran Platform connector or external logging services. If there are entries coinciding with the date of the sync, wait for the sync to complete. We also recommend that you find what happened within Salesforce that resulted in the purging of its recycle bin.
NOTE: Salesforce purges its recycle bin periodically.
New tables added: Check if the connector's schema change settings are set to Allow All. If so, the connector automatically starts syncing any newly added table in the source.
Many updates received: A lot of updates in the source can cause longer incremental syncs. You can identify tables with higher numbers of records_modified using our free Fivetran Platform connector or external logging services. Check the SystemModStamp field in the table to see if it has a recent date.