Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Stale Salesforce Data & Formula Fields

If you've noticed some out-of-date Salesforce data in your data warehouse, we recommend checking to see if the field in question is a formula field. 

Formula fields are algorithms that derive their value from other fields, expressions, or values. These fields can automatically calculate their value based on other fields.

Impact on Data Freshness

A formula field that's calculated with another object's field might not cause the LastModifiedDate field to change. Because Salesforce data is incrementally replicated based on updated/modified_at, formula fields may not always be identified as having new values.

For example: Opportunity.Custom_Field_Account_Name__c is an opportunity field that calculates the Account Name. If the Account Name changes, Salesforce will not indicate that the Opportunity formula field has changed, meaning the Opportunity record won't be detected by an incremental update.

Workarounds for Formula Fields

If you're using it as a join, you could recreate the join using SQL.

If the field isn't a join, depending on what you need, you could still recreate it using SQL or change the field to be a native field that's updated through a workflow or apex trigger.

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!