Skip to main content
Adds new rows to the existing table without modifying existing data. No deduplication is performed, so you may end up with duplicate records.
This strategy is best used when unique keys aren’t required. For key-based updates, use one of the Merge options instead.

​
Example: Append daily sales

A sales table receives a new batch of orders each day. The incoming dataset is appended to the existing table so that all historical orders are preserved.
Existing target tableIncoming datasetResulting target tableProphecy appends every row from the incoming dataset to the target table without modifying or removing existing rows. In this example, orders 301 and 302 are added while orders 101 and 102 remain unchanged.