Upserting data

Upserting refers to the INSERT or UPDATE activity in a database or any analytical data store that supports it. We have already seen UPSERT as part of the batch activity, in the Upserting data section of Chapter 9, Designing and Developing a Batch Processing Solution. ASA supports UPSERT with CosmosDB. CosmosDB is a fully managed, globally distributed No-SQL database. We will learn more about CosmosDB in Chapter 14, Optimizing and Troubleshooting Data Storage and Data Processing, in the Implementing HTAP using Synapse Link and CosmosDB section.

ASA has two different behaviors based on the compatibility level that is set. ASA supports three different compatibility levels. You can think of compatibility levels as API versions. As and when ASA evolved, the compatibility levels increased. 1.0 was the first compatibility version, and 1.2 is the latest compatibility version. The main change in version 1.2 is the support for the AMQP messaging protocol.

You can set the...