Bulk updating Delta tables in Databricks

Dipesh
New Contributor II

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
Databricks MVP

yes by using MERGE statment


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

View solution in original post