cancel
Showing results for 
Search instead for 
Did you mean: 
Get Started Discussions
Start your journey with Databricks by joining discussions on getting started guides, tutorials, and introductory topics. Connect with beginners and experts alike to kickstart your Databricks experience.
cancel
Showing results for 
Search instead for 
Did you mean: 

time travel with DLT

leelee3000
Databricks Employee
Databricks Employee
Needed some help with Time Travel with Delta Live tables
 
We were trying to figure out if we can go in and alter the history on this table, and what would happen to data that we mass upload?  By this we mean we have data from the past that we would like to upload, and were wondering what the Time Travel information would look like for that.  
 
Our concern is that since it already happened and potentially schema changes took place, data was updated etc how would that look within the Delta Live tables and its time travel output. #deltalivetables #DLT #timetravel
2 REPLIES 2

leelee3000
Databricks Employee
Databricks Employee

I'm assuming Time Travel in Delta Lake doesn't allow you to change historical data versions?

BigRoux
Databricks Employee
Databricks Employee

Delta Live Tables leverage Delta Lake, or Delta Tables.  Delta tables, through transactions (e.g. insert, update, delete, merges, optimization) create versions of said Delta Table.  Once a version is created it cannot be altered, it is immutable.  You can always roll back (restore) to an ealier version of the Delta table, this action will create a new version of the table.  The older versions will always be present unless vacuum is run.

Hope this helps.

Louis

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