Upserting data
Upsert refers to UPDATE or INSERT transactions in data stores. The data stores could be relational, key-value, or any other store that supports the concept of updating rows or blobs.
ADF supports upsert operations if the sink is a SQL-based store. The only additional requirement is that the sink activity must be preceded by an Alter Row operation. Here is an example screenshot of an ADF sink with Allow upsert enabled.
Figure 9.29 – Upsert operation in ADF
Once you have saved the preceding setup, ADF will automatically do an upsert if a row already exists in the configured sink. Let's next look at how to regress to a previous state.
