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
1
votes
Hello and welcome! What have you already done? Usually, when using data factory to move data, you would like to have a stored procedure to do the data transformation for you. The procedure could use a merge operation to insert/update/delete the data. Usually, on the sink side, you chose a table and a stored procedure that relates to that data, with a table type that represents it. Can you provide more information on what you've done?
– rafael.braga
I have few table in my source database , which is azure SQL database i need to copy this data to my azure SQL data warehouse .I tried to do this activity with the reference of this link .docs.microsoft.com/en-us/azure/data-factory/…. Here the sink is SQL data base. Insted of SQL data base i use data warehouse in my senario. But in data warehouse I am not able to create type .Says it is no allowed to create type.So I need an alternative way to do this activity.
– Eldho Baby M
1 Answers
1
votes
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.
