Comment
Databricks Employee
Databricks Employee

The following example made this more clear for me:

MERGE .... ON source.id = target.id
WHEN MATCHED AND source.value = target.value
WHEN NOT MATCHED THEN INSERT

Screenshot 2025-04-08 at 10.44.42 AM.png