Merge Command¶

Delta Lake supports merging records into a delta table using the following high-level operators:

• MERGE INTO SQL command (Spark SQL)
• DeltaTable.merge

Single INSERT-only MERGEs¶

There is a special handling of single INSERT-only MERGEs.

MERGE INTO merge_demo to
USING merge_demo_source from
ON to.id = from.id
WHEN NOT MATCHED THEN INSERT *;

Demo¶

• Demo: Merge Operation