To illustrate, you write incorrect data to a Delta Lake table in Databricks. Using Time travel you can correct it. Time travel lets you access earlier versions of a Delta table. This makes it possible to revert to a point before the incorrect data was written.
Table of contents
Databricks Time Travel: Recover a Delta Lake Table
Here are the commands that show how the Time travel technique works.
Choose the Correct Version
First, choose the version of the Delta Lake table that holds the correct data. You can view the history of changes to a Delta table using the DESCRIBE HISTORY command in Databricks.
DESCRIBE HISTORY EMPThis command displays a list of all Delta table versions, including timestamps and actions taken.
Restoring the Table
Select the appropriate version by checking all timestamps. Use the RESTORE command to recover data from that version.
RESTORE EMP TO VERSION AS OF 2
Verify the Data
Finally, after restoring the table, verify that the correct data has been recovered by querying the table.
SELECT * FROM EMPFinally, check the recovered data to ensure it matches your previous data.
Conclusion
Using Delta Lake’s time travel feature, you can go back to an earlier version of a Delta table and restore it to a state without the wrong data. However, keep in mind that retention policies can lead to the automatic deletion of older versions. It’s crucial to recover the table quickly before the version you need is gone.
Srinimf 
You must be logged in to post a comment.