Forum Discussion
Upsert data to Lakehouse Table using copy data
Hi Alaahady ,
You need to transfer table from on-premises sql server to datalake using incremental update (upsert) . I have provided all the possible work arounds. But you are expecting Low code / No code. You can try the "Copy job" in Data Factory, makes it easy to move data from your source to your destination without creating a pipeline.
Please refer below links.
How to create a Copy job in Data Factory - Microsoft Fabric | Microsoft Learn
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
Hi Alaahady ,
spaceman127 has given Copy activity approach which is more usefull and you might be able to use it in your solution. On the other hand, Copy Job Fabric Item can also be used to for Upsert operation. Although, Copy Job item can't be included in Data pipeline as activity which is a limitation for now.