topic Re: How to update table using merge from value rather than from a table in Data Engineering

How to update table using merge from value rather than from a table

User16826994223 — Fri, 25 Jun 2021 16:22:23 GMT

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?

Re: How to update table using merge from value rather than from a table

User16826994223 — Fri, 25 Jun 2021 16:22:59 GMT

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