https://community.databricks.com/t5/data-engineering/bulk-updating-delta-tables-in-databricks/m-p/10408#M5595 <P>Hi All,</P><P></P><P>I have some data in Delta table with multiple columns and each record has a unique identifier.</P><P>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.</P><P></P><P>Is there any way i can perform bulk update on Delta tables for all the unique records and their columns at once?</P><P></P><P>Thank you.</P> Tue, 31 Jan 2023 14:19:58 GMT Dipesh 2023-01-31T14:19:58Z https://community.databricks.com/t5/data-engineering/bulk-updating-delta-tables-in-databricks/m-p/10408#M5595 <P>Hi All,</P><P></P><P>I have some data in Delta table with multiple columns and each record has a unique identifier.</P><P>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.</P><P></P><P>Is there any way i can perform bulk update on Delta tables for all the unique records and their columns at once?</P><P></P><P>Thank you.</P> Tue, 31 Jan 2023 14:19:58 GMT https://community.databricks.com/t5/data-engineering/bulk-updating-delta-tables-in-databricks/m-p/10408#M5595 Dipesh 2023-01-31T14:19:58Z https://community.databricks.com/t5/data-engineering/bulk-updating-delta-tables-in-databricks/m-p/10409#M5596 <P>yes by using MERGE statment</P> Tue, 31 Jan 2023 19:12:31 GMT https://community.databricks.com/t5/data-engineering/bulk-updating-delta-tables-in-databricks/m-p/10409#M5596 Hubert-Dudek 2023-01-31T19:12:31Z