Generate table using Time travel feature

BigQuery Time travel feature

BigQuery has a feature called Time travel. It allows you to query a table at a specific point in time. This is useful for debugging and auditing purposes.
You can read more about it in the official documentation.
Time traveller default value is 7 days.

Configure Time Travel Query

Select source and destination tables and adjust the time travel point

Source Table
Destination Table
Time Travel Target

Slide to select a point in time within the last 7 days

Advanced Options
Generated SQL Query

Your time travel query is ready to use

Click the copy button to copy the query to your clipboard


Company

About us

Copyright © BQ Booster 2025