Time travel allow BigQuery customers to query data that was updated or deleted, restore a dataset or table covering by default the last seven days. You can configure it at:

  • project-level
  • dataset-level BigQuery provides a fail-safe period. During the fail-safe period, deleted data is automatically retained for an additional seven days after the time travel window, so that the data is available for emergency recovery.
  • You can only recover data by contacting customer care.

References

Data retention with time travel and fail-safe | BigQuery. [Online]. Available at: https://cloud.google.com/bigquery/docs/time-travel#time_travel [Accessed 8 May 2025].