Upserting Data

Upserting refers to the INSERT or UPDATE activity in a database or any analytical data store that supports it. You have already learned about UPSERT as part of the batch activity, in the Upserting Data section of Chapter 5, Developing a Batch Processing Solution.

Note

This section primarily focuses on the Upsert data concept of the DP-203: Data Engineering on Microsoft Azure exam.

ASA supports UPSERT with Cosmos DB, which is a fully managed, globally distributed No-SQL database. 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 the ASA evolved, the compatibility levels increased—1.0 is 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. You can set the compatibility level, as shown in Figure 6.36.

To find the ASA jobs you...