Is it possible to use a business key instead of '_rid' while handling a Cosmos analytical CDC in ADF?
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.
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?