Salesforce Deleted Records

Add deleted records to your Salesforce data extracts.

These two Data Productivity Cloud pipelines demonstrate how to add deleted records to your Salesforce data extracts, using the Report table as an example.

Start with the Salesforce Report Extract orchestration pipeline.

The Data Productivity Cloud Salesforce Query component has an implicit filter IsDeleted = false. To fetch all records - including deleted - it’s necessary to run a second Salesforce Query with an explicit filter IsDeleted = true.

Once both extracts have completed, union the records into a single table for ease of use downstream. This is done in the Salesforce Report unify transformation pipeline.

These pipelines use the Report table as an example.

Downloads

Licensed under: Matillion Free Subscription License

• Download Salesforce-Deleted-Databricks.zip
  • Target: Databricks
• Download Salesforce-Deleted-Redshift.zip
  • Platform: AWS
  • Target: Redshift
• Download Salesforce-Deleted-Snowflake.zip
  • Target: Snowflake

Installation Instructions