cancel
Showing results for 
Search instead for 
Did you mean: 
Get Started Discussions
cancel
Showing results for 
Search instead for 
Did you mean: 

time travel with DLT

leelee3000
New Contributor III
New Contributor III
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
New Contributor III
New Contributor III

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

BigRoux
New Contributor III
New Contributor III

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