Databricks support updating multiple target rows with single matching source row in merge query?

Shruti12
Databricks Partner

Hi,

I am getting this error in merge statement. DeltaUnsupportedOperationException: Cannot perform Merge as multiple source rows matched and attempted to modify the same target row in the Delta table in possibly conflicting ways.

Does Databricks support updating multiple records with single row coming from source in a merge query (we are getting multiple target rows based on match condition for each single source row)?  Basically, source- 1 row, Target- many rows