Improve Snapshot Data Recipe Performance with Optimized Upsert and Delete Actions (Generally Available)

Decrease processing time with quicker data recipe runs. Instead of processing all rows in the snapshot data, the optimized upsert and delete actions run incrementally on subsets of the data resulting in faster runs. This feature is now generally available.

Where: This change applies to Salesforce Data Pipelines in Lightning Experience and Salesforce Classic. CRM Analytics is available for an extra cost in Enterprise, Performance, and Unlimited editions.

How: Re-create your recipes to take advantage of this optimization, ensuring the snapshot data contains a primary key field. In the output node, select Existing Dataset and then the Upsert or Delete operation to use the optimized features.

Use the upsert and delete operations for optimized writing to an existing dataset.