---
schema_version: "1"
id: 0622d513558dc17bdcefa3be9c46d5f528c2011a5cce5a6acf14f3789f17c1eb
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_bi_integrate_optimized_upsert_delete_ga.md
canonical_url: https://help.salesforce.com/s/articleView?id=release-notes.rn_bi_integrate_optimized_upsert_delete_ga.htm&release=262.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 2b096cfe3b14ba10e485437138542d4f1bbe1f756cbbbfc4c2954207417e9746
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 CRM Analytics 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=analytics.bi_integrate_recipe_output_results.htm&language=en_US)