User16826994223
Databricks Employee
Databricks Employee

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