Is it possible to use a business key instead of '_rid' while handling a Cosmos analytical CDC in ADF?

Sharat Ravindra Hegde 0 Reputation points
2024-01-23T11:56:14.3733333+00:00

While processing data from Cosmos Analytical CDC to a Delta lake using ADF I have below requirement. For the UPSERT, DELETE scenarios we don't want to use '_rid' column as mentioned in the below document. https://learn.microsoft.com/en-us/azure/cosmos-db/get-started-change-data-capture Instead, we want to use another business key which is available in the data set. When we configure the mapping data flow with the _rid as key column UPSERT and DELETE is working nut same is not the case when the Key column is changed to any other unique columns in the data set. User's image

It's not clear in the document that whether with only '_rid' analytical CDC deletes will be reflected on Sink or it will with any other unique business key columns? Can I get some help on this please?

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,749 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,209 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.