Dataverse CDC: SinkModifiedOn vs VersionNumber

Question

Hi All, I wondering if anyone on that forum has an experience with Change Data Capture (CDC) on Microsoft Dataverse tables exported to Azure Data Lake via Azure Synapse Link for Dataverse? Specifically, I want to learn the functional differences between SinkModifiedOn and VersionNumber columns and why this document Read the incremental updates of Dataverse data - Power Apps | Microsoft Learn suggest using the first one only to read the incremental updates of Dataverse data.

In other words, what I am after for is good understanding for the purpase these two columns and why VersionNumber can't be employed to read incremental updates of Dataverse data.

Thank you!

Answer 1

Hello @Oleg Moiseyenko ,

As per the conversation with product team, it is confirmed that - For version number and Sinkmodifiedon, user should use version number first (please note that user need to do deduplication at their end), and if there is duplicated version number, user should use Sinkmodifiedon

The product team is working on updating the public document content to reflect the latest guidelines on this topic.

Hope this information helps.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how