Why Does the _fivetran_synced Column Value Update When the Source Data Hasn't Changed?

Question

Why does the _fivetran_synced column value update when the source data hasn't changed?

Environment

The following connectors:

• Salesforce
• Salesforce Sandbox

Answer

We update the _fivetran_synced value when we check a row for changes. This happens when you perform a full re-sync or we re-import the table.

We re-import tables for Salesforce objects that meet the following criteria:

• The replicateable property is set to FALSE.
• The replicateable property is set to TRUE, but API responses don't contain the SystemModeStamp, LastModified, CreatedDate, or LoginTime timestamp fields.
• The replicateable property is set to TRUE, and API responses contain a timestamp field, but we're unable to capture deletes. For more information, see our Delete capture limitations documentation.

To learn more, see our Salesforce Re-import tables documentation.