Hubert-Dudek
Databricks MVP

In my opinion, when possible MERGE statement should be on the primary key. If not possible you can create your own unique key (by concatenate some fields and eventually hashing them) and then use it in merge logic.


My blog: https://databrickster.medium.com/