Question

I have a process in Salesforce which temporarily creates records and then subsequently deletes them seconds, minutes or days after. Are these records captured by Fivetran?

Environment

Salesforce connector

Answer

Yes - these records are captured. During a sync cycle, Fivetrans get deleted records from Salesforce via the regular Salesforce soft deletes or via the deleted() endpoint (both Salesforce hard deletes and Salesforce soft deletes). If salesforce hard deletes a particular record then we mark the is_deleted as true. If the is_deleted field does not exist, Fivetran will mark the  _fivetran_deleted field as true.