I'm a new user in the Azure data factory. I tried to perform copy activity in between Azure database as the source and Azure data warehouse as a target . In that, I am not able to perform an update into target using data factory. In which Source as Azure SQL server and target as the Azure data warehouse. And how to update the field in data warehouse table in Azure using ADF when the data warehouse is a sink
From your pasted link I assume what expected is incrementally copy data from Azure sql database to Azure data warehouse.
In this case no need to modify the sink database, instead finish the modification before loading into sink table.
I followed the steps in this article, in which the target is: Azure Blob storage, I changed it to: Azure data warehouse. And the test result is successfully implemented data copying from Azure database to Azure data warehouse incrementally.