What Happens to Records That Exist Temporarily?link

Questionlink

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?

Environmentlink

Connector: Salesforce

Answerlink

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?.