DataYatriSpark, seen under the hood
Simulate

Simulation/Databricks

Educational simulation
Databricks

Delta MERGE

Match keys, rewrite files, commit one atomic snapshot.

Watch the canvas:targetsource changesrewritten fileLive simulation
Target · ordersid 1id 2id 3Source · changesid 2 updid 4 newWHEN MATCHED UPDATE · WHEN NOT MATCHED INSERT · WHEN MATCHED DELETEFiles after MERGEpart-000untouchedpart-001rewritten (id 2)part-002added (id 4)Commit 12 · atomic snapshotadds + removes in one log entry
MERGE rewrites files, then the log swaps the snapshot.