How Can I Query Points in Time in Salesforce Using History Mode?

Fivetran's history mode allows you to analyze Salesforce objects as they existed at specific points in time.

How to query for a specific point in time

To get data that was active at a specific point in time, run the following query:

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

How to interpret the results

This query returns only the records that were active during the specified time frame. If a record was deleted before the start or created after the end, it won’t appear.