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

Salesforce

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