If your SQL source doesn't have SQL Server CDC with net_changed enabled or doesn't have any time-based incremental columns, then maybe the columns the tables in your source will be unavailable for selection.
How to update and delete a row using Azure Data Factory Change Data Capture
I am exploring Azure Data Factory CDC feature, and I am trying to perform the CDC from one SQL table to another SQL table, also the SQL table in the source has a primary key.
Whenever a new row is added to the source table, it gets added to the destination SQL table.
However, when an existing row is modified/updated in the source table, it adds a new row in the destination SQL table, instead of updating it.
Is there a way to achieve update and delete with Azure Data Factory CDC?
In the answer section of this question (https://stackoverflow.com/questions/75233423/how-are-changes-count-calculated-in-azure-data-factory-change-data-capture), the author says to specify a Primary Key, however in the current ADF CDC UI, I am unable to see the Keys column.
Please let me know if the update and delete is possible using Azure Data Factory CDC.
2 answers
Sort by: Most helpful
-
-
ShaikMaheer-MSFT 38,046 Reputation points Microsoft Employee
2024-04-29T16:55:59.4433333+00:00 Hi jigsm,
Thank you for posting query in Microsoft Q&A Platform.
Kindly check my video on CDC and fellow same steps. That helps to avoid this error. Below is the video link. CDC (change data capture) Resource in Azure Data Factory
Hope this helps. Please let me know how it goes.
Please consider hitting
Accept Answer
button. Accepted answers help community as well.