Change Data Capture in Azure Data Factory

[@ApoorvaW]

Great Feature. I was wondering if there is a way to override the checkpointing while using the Native CDC functionality. Consider a scenario where something went wrong with the destination table, and it had to be dropped and recreated. How would I instruct the pipeline to start from the beginning? Because, as per my understanding pipeline is aware of the the CDC source only and not the target.

[@ginosoriano1047]

No way to know if rows is deleted or updated or inserted. Even for Delta format and assigned the Key, no Key to identify the deleted rows.

[@dattrieuds]

That's an amazing feature! When will CDC be in the new Data Factory in Fabric?

[@wanderingengineer16]

I am fetching data from the Cosmos Analytical store with CDC enabled by default. I have 2 documents in the cosmos store and pipeline runs and fetch the 2 records for me. What if the pipeline fails while processing 2 documents and I need to re-run the pipeline. Is it possible to get the 2 records again? If yes then please let me know how we can achieve this.

[@BidyadharBarik-m7m]

How will connect from SQL server on-premise to ADF CDC ?

[@christopherblaisdel]

Does anyone know if this is available in Microsoft Fabric yet?

[@BidyadharBarik-m7m]

How to connect sql server on-premise to ADF CDC preview ?