What Happens to Records That Exist Temporarily?link
I have a process in Salesforce that temporarily creates records and then deletes them in seconds, minutes, or days. Are these records captured by Fivetran?
During a sync, Fivetran fetches temporarily created records.
Salesforce uses both soft-deletes and hard-deletes to delete records. During a sync cycle, Fivetran fetches both soft-deleted and hard-deleted records. If Salesforce hard-deletes a record, Fivetran marks the
is_deleted field as
true in the destination table. If Salesforce soft-deletes a record and the
is_deleted field does not exist, Fivetran then marks the
_fivetran_deleted field as
true in the destination table.
For more information, see How Does Fivetran Capture Deletes?.