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

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local community—sign up today to get started!

Sign Up Now