---
schema_version: "1"
id: a2b79f4c1ecba1163b1fc948771fdbe6d6faeb5c717f960b737cef8b9c567232
title: Improve Snapshot Data Recipe Performance with Optimized Upsert and Delete Actions (Generally Available)
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/release-notes/262-0-0/rn_data_pipelines_integrate_optimized_upsert_delete_ga.md
canonical_url: https://help.salesforce.com/s/articleView?id=release-notes.rn_data_pipelines_integrate_optimized_upsert_delete_ga.htm&release=262.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: f4c11b41503295673235dd01306c9721d054e04e67c9d85dc781f977771b65a8
description: 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.
products:
  - Cross Cloud
release: "262"
---
# 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.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-release-notes-salesforce_release_notes-262-0-0-production-enus/e945111b-3e0a-4011-accc-d5949363bfcc/salesforce_release_notes/images/analytics/rn_bi_integrate_output_operation.png)

#### See Also

- [_Salesforce Help_: Output Node: Write Recipe Results to a Dataset or External System](https://help.salesforce.com/s/articleView?id=xcloud.sdp_recipe_output_results.htm&language=en_US)