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
I have carried out some more tests.
Upsert in the copy activity is very sensitive depending on the table and errors are sometimes not reproducible.
In my first test it worked wonderfully. Afterwards, with the same settings, it no longer worked.
As also mentioned, this feature is also in preview.
I would also go to notebooks as
BhaveshPatel already wrote and I also mentioned in my first answer.
Best regards