How to Query Points in Time in Salesforce History Mode

Use Case

You want to use Fivetran's history mode for Salesforce to analyze objects at specific points in time.

Environment

Salesforce

Recommendations

Use _fivetran_start and _fivetran_end in your query:

select * 
from salesforce.opportunity
where [timestamp] between _fivetran_start and _fivetran_end;

NOTE: We do not capture deletions of objects that you deleted and then undeleted.

Context

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