Hi @andrew li​ Merge functionality is a part of Delta Lake API and not native dataframe API. Only when you are writing the data in delta format, you can use this functionality.

Please check the below link to achieve Merge using delta lake API.

https://learn.microsoft.com/en-us/azure/databricks/delta/merge