Forum Discussion

terrychang10's avatar
terrychang10
Icon for Microsoft rankMicrosoft
Dec 05, 2023

How to delete the modified rows in the data movement from Azure SQL MI to Azure Data Lake Gen 2

Customer is using ADF to move data from Azure SQL MI to Azure data lake gen2 regularly. When customer modified the row in Azure SQL MI, then the ADF trigger by time, the new table of Azure SQL MI will be move to Azure Data Lake, but the modified row, which customer expected will be replace by new data, will be still there in Azure Data lake storage. How to setup the ADF or it will require CDC enable in Azure SQL MI to achieve the expected outcome?

No RepliesBe the first to reply

Resources