Save DeltaSet

Saves all changes in a DeltaSet to a Snowflake table by applying inserts, updates, and deletes.

A DeltaSet represents a set of row-level changes captured from a source such as the Writeback Table visual for Power BI. This action replays those changes against a Snowflake target table, making it the standard way to persist user edits from Power BI back to Snowflake.

Example
This flow receives a DeltaSet of changes from a Power BI writeback table and saves those changes to a Snowflake table by applying inserts, updates, and deletes.

Properties

Name	Required	Description
Title	No	A display label for this action in the flow editor.
Connection	Yes	The Snowflake connection to use.
DeltaSet	Yes	The DeltaSet containing the changes to apply.
Target table	Yes	The Snowflake table to save changes into. If this differs from the table the data is read from in the Power BI model, ensure the target table has columns with matching names and data types as defined in the Writeback Table visual's column definitions.
Save data options	No	Overrides the default behaviour for applying DeltaSet changes. See Save data options below.
Command timeout (sec)	No	How long to wait before the command times out. Default is 120 seconds.

Save data options

Use save data options to control how individual columns are handled when changes are applied. This is useful when the default key-matching or update behaviour needs to be overridden for specific columns.

Property	Description
Column name	The column to configure behaviour for.
Use as update or delete key	When enabled, this column is used to match rows when applying updates or deletes, instead of the keys defined in the DeltaCells.
Allow updating data in this column	When set to false, this column will not be updated even if the DeltaSet contains changes for it.
Enable identity insert	Not applicable for Snowflake.