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:ย 

Merge DLT with Delta Table

erigaud
Honored Contributor

Is there anyway to accomplish this ? I have an existing Delta Table and a separate Delta Live Table pipelines and I would like to merge data from a DLT to my existing Delta Table. 

Is this doable or completely impossible ?

3 REPLIES 3

-werners-
Esteemed Contributor III

Seems to me that it is possible. Delta Live tables is in fact a declarative framework to automate a lot in data pipelines.
So it is not a table type in fact (I always wondered why they called it like that).  As DLT uses Delta Lake, you could create a DLT which merges the other DLTs in your delta lake table, taking into account the limitations of dlt of course.

Something like this

 

Faisal
Contributor

This is doable, use LIVE keyword while matching the delta table to delta live table in merge.

LeifBruen
New Contributor II

Merging data from a Delta Live Table (DLT) into an existing Delta Table is possible with careful planning. Transition data from DLT to Delta Table through batch processing, data transformation, and ETL processes, ensuring schema compatibility. 

as

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group