Data engineering·Files, formats and table layers
you queried the table as it stood before this morning's bad run, without restoring anything.
Time travel
Also calledsnapshot query, as-of query
Querying a previous version of a table by snapshot id or timestamp, made possible because a table version is a list of immutable files. It turns a class of recovery from an incident into a select statement, and it makes auditing and debugging a bad load dramatically cheaper. Its limit is retention: snapshots expire, and expiry is what allows deleted files to actually be deleted, which matters both for cost and for privacy requests.