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 *;