Edit on GitHub
How to Query Points in Time in Salesforce History Modelink
Updated 12 days ago
Use Caselink
You want to use Fivetran's history mode for Salesforce to analyze objects at specific points in time.
Environmentlink
Recommendationslink
Use _fivetran_start
and _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.
Contextlink
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