Forum Discussion
Upsert operation Eventstream into a delta table
For now I would run a notebook (Spark.)
Or - and mind you, I haven't tested this on Onelake, only SQL - use a UDF in Kusto that upserts to a OneLake shortcut/external table (https://learn.microsoft.com/en-us/fabric/real-time-intelligence/onelake-shortcuts?tabs=onelake-shortcut)
for event stream and lakehouse integration today, append is the already operator supported. there is one backlog item tracking the "delete" and "upsert" operator support for lakehouse
thank you. so how do i do an upsert to a delta table then?
For now I would run a notebook (Spark.)
Or - and mind you, I haven't tested this on Onelake, only SQL - use a UDF in Kusto that upserts to a OneLake shortcut/external table (https://learn.microsoft.com/en-us/fabric/real-time-intelligence/onelake-shortcuts?tabs=onelake-shortcut)