Dataverse CDC: SinkModifiedOn vs VersionNumber

Oleg Moiseyenko 1 Reputation point

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!

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,549 questions
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 43,427 Reputation points Microsoft Employee

    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 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    0 comments No comments