Delta feature to query an older table version through TIMESTAMP AS OF, VERSION AS OF or @v. Needs that version's data files and log to still exist.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Time travel in context, with comparison tables and the common traps.
Terms in this definition
- Event
Table in Log Analytics where entries from Windows event logs are kept.
Related terms
- Temporal table
Lets you ask what the data looked like on a past date by keeping its change history. Azure Databricks options are SCD type 2, change data feed, or Delta history with time travel; retention and purpose vary.
- VACUUM
Removes data files that a table no longer references once they are older than the retention period, 7 days unless changed. Versions older than that can no longer be reached with time travel.