What is Time Travel

Definition

Time travel is a data platform capability that lets users query or restore a table as it existed at a previous point in time or version, using retained historical snapshots to support reproducible analysis, auditing, and recovery from erroneous changes.

« Back to Glossary Index

Lets users query a table exactly as it was at a past timestamp or version
Enables instant rollback after a bad write or accidental deletion
Supports reproducible analysis by pinning queries to a fixed data version
Simplifies auditing by reconstructing data state for any earlier moment

Glossary: Delta Lake

Real World Example

After a faulty job overwrites a sales table, an engineer uses time travel to restore the version from one hour earlier in a single command, avoiding a lengthy restore from backups.

FAQs

How does time travel work?

Table formats retain previous versions or snapshots, so queries can reference an earlier timestamp or version number to read past state.

What is time travel used for?

Recovering from bad writes, reproducing analyses on a fixed version, auditing changes, and debugging data issues.

Is historical data kept forever?

No, retention is configurable; older versions are eventually expired to control storage cost.