Delta Lake supports merging records into a delta table using the following high-level operators:
- MERGE INTO SQL command (Spark SQL)
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 *;