Question
How does Fivetran capture deletes from Salesforce?
Environment
Connector: Salesforce
Answer
In Salesforce, there are two types of deletes - soft deletes and hard deletes. You can find out more about different Salesforce deletes here.
Fivetran gets soft-deleted records from Salesforce using the SObject Get Deleted API endpoint.
When you soft-delete a record, it is stored in the Recycle Bin for 15 days, after which the records will be hard-deleted. Salesforce does not provide any way to fetch the hard deleted records.