Why Do Record Counts Differ Between Old and New Salesforce Connections?

Question

Why do I see different record counts between old and new Salesforce connections?

Environment

Connector: Salesforce

Answer

Record counts may differ between old and new Salesforce connections for the following reasons:

Deleted records

When records are deleted in Salesforce, they are first soft-deleted and moved to the Recycle Bin. After 15 days, Salesforce permanently removes them as hard deletes. An old connection may have synced records while they were still in the Recycle Bin. A new connection can’t access records that were deleted more than 15 days before the connection was created, so the new connection won't sync those records.

To confirm whether missing records were deleted, check whether _fivetran_deleted = TRUE in the old connection. If so, the records were deleted and are no longer accessible to the new connection. For more information, see How Does Fivetran Capture Deletes From Salesforce?.

Source permissions

Permission changes can cause old and new connections to have access to different objects or records, even if they share the same authenticating user.

Sync timing differences

Temporary mismatches can occur when the old and new connections have different last sync times.