cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Hubert-Dudek
Esteemed Contributor III

yes by using MERGE statment

View solution in original post

1 REPLY 1

Hubert-Dudek
Esteemed Contributor III

yes by using MERGE statment

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!