How to Query Points in Time in Salesforce History Modelink
Updated 12 days ago
You want to use Fivetran's history mode for Salesforce to analyze objects at specific points in time.
_fivetran_end in your query:
select * from salesforce.opportunity where [timestamp] between _fivetran_start and _fivetran_end;content_copy
NOTE: We do not capture deletions of objects that you deleted and then undeleted.
When you query between points in time, your query will always meet the following criteria:
- The rows returned were not deleted at that point in time
- The rows returned were active at that point in time