Manually Updated Values Aren't Reflected in the Destination

Issue

I have manually updated some values in Salesforce, but the values in the destination don't reflect the changes.

Connector: Salesforce

To manually re-sync tables containing out-of-date values, do the following:

In your Fivetran dashboard, go to your Salesforce connector page.
In the top right corner, pause the connector by setting the ENABLED toggle to OFF.
Select the Schema tab.
Locate and hover over the affected table.
On the right side of the screen, click Resync.
In the confirmation pop-up window, click Start re-sync.
Repeat steps 4 through 6 for each affected table.
Unpause the connector by setting the ENABLED toggle to ON.

To detect changes and additions in your Salesforce data, we monitor the following timestamp fields within Salesforce's API responses:

However, destination data may not always reflect recent changes. Below are resolution steps for common scenarios:

Manual field updates not triggering incremental sync: Some manual updates in Salesforce may not update incremental timestamp fields, preventing these changes from syncing to your destination. To resolve this, manually re-sync the data or wait until another field change updates the timestamp fields.
Adding new columns for existing records: When you add a new column in Salesforce, incremental timestamp fields for existing records are not updated. As a result, we are unable to sync older records for the new columns during incremental syncs. To address this, resync the affected table. A resync is mandatory for incremental tables, while re-import tables naturally include updates for all records in subsequent syncs.
Salesforce operations and timestamp fields: Some Salesforce operations may update records without modifying incremental timestamp fields. To fix this, perform a table resync. Additionally, contact our support team to address potential improvements or update documentation with relevant examples.