Bulk updating Delta tables in Databricks

[Dipesh]

Hi All,

I have some data in Delta table with multiple columns and each record has a unique identifier.

I want to update some columns as per the new values coming in for each of these unique records. However updating one record at a time is taking a lot of time.

Is there any way i can perform bulk update on Delta tables for all the unique records and their columns at once?

Thank you.

[Hubert-Dudek · Accepted solution]

yes by using MERGE statment