06-25-2021 09:22 AM
My question is how can we do an upsert directly, that is, without using a source table. I would like to give the values myself directly.
s there a simple way to do that for Delta tables?
A source table can be a subquery so the following should give you what you're after.
MERGE INTO events USING (VALUES(...)) // round brackets are required to denote a subquery ON false // an artificial merge condition WHEN NOT MATCHED THEN INSERT
*
View solution in original post
