K_Anudeep
Databricks Employee
Databricks Employee

Hey @shanisolomonron ,

Yes, you are right. The above sequence of actions is always true for MERGE and UPDATE .For DELETE , you don't see any Add a new file (step 3)

And yes, if the table has the DV feature enabled, the writer/runtime supports DVs for that specific command, and you’re not in a special mode (append-only, UniForm, certain HMS cases), then your expected remove → add(with DV) → add(new files) pattern is exactly what happens.

Please let me know if you have any further questions.

Anudeep