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?

0 Replies