Why Does _fivetran_synced Update for Salesforce Connections When Source Data Hasn't Changed?

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 SystemModStamp, 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.