I have a process in Salesforce that temporarily creates records and then subsequently deletes them seconds, minutes or days after. Are these records captured by Fivetran?
Yes - these records are captured. During a sync cycle, Fivetran gets 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.