Support UPSERTs and DELETEs when copying data into Lakehouse Tables from Pipeline copy activity, as opposed to Appending new rows

[amolteni]

be able to do incremental loading from a pipeline.

[stevelysik1]

Customers want to update records from Dataflows and not just append or replace. Just yesterday Sunrise Living was having challenges with UPSERT's in Synapse.  Thank you.

[v-rkuruvinak]

Yes would be great to see a smooth upsert feature in fabric

[SandeepPawar1]

Please prioritize this feature to support UPSERT

[aje2]

Hey,

Pipeline upsert is available, just hidden; a Microsoft Rep will be able to get it running for you - although it has been buggy,

It would be powerful to have this for Dataflows as well as Pipelines.

[nishalit]

Upsert to Lakehouse Tables via Pipeline copy activity is in roadmap. 

[thijs2]

Really interested in having the option to Upsert or Insert, Update & Delete using copyData activity!

[fredy_herrera]

I would really appreciate having this Upsert feature in Fabric Pipelines as it is in Azure Data Factory. thanks.

[nishalit]

My current implementation involves obtaining data from multiple APIs simultaneously every day. I want to implement a process that does not rewrite or overwrite new data but appends it, taking into consideration the possibility of duplicates in consecutive API calls.

[Phil_Koay1]

Even though Administrator comment says it is included on roadmap, I can't see it as of 22/Feb/2024

[Justin_White1]

Is there any update on when this feature will be available?