CODEWITHSUNDEEP
google-cloud-platformgoogle-bigquery
Lakshminarayanan Shanmugasunda
Lakshminarayanan Shanmugasunda

Reputation: 9

GCP Bigquery - Time Travel - Max and Min Window time for a table

I understand the BigQuery provides 7 days time travel. I'm trying to get Max and Min of time travel possible for each table like Min and Max of timestamp. Is this information available in any of BigQuery metadata tables if not How is it possible to find out.

Upvotes: 0

Views: 3015

Answers (1)

Prajna Rai T
Prajna Rai T

Reputation: 1820

The feature of the time travel window is in Pre-GA, you will have to enroll in the preview to use this feature.

You can set the duration of the time travel window, from a minimum of two days to a maximum of seven days. Seven days is the default. You set the time travel window at the dataset level, which then applies to all of the tables within the dataset.

You can configure the time travel window to be longer in cases where it is more important to have the option of recovering the data, and to be shorter where that isn't a concern. Using a shorter time travel window allows you to save on storage costs. It can also allow you to conform to data retention policies that require hard deletion of data in a specific time frame.

To update the time travel window you can refer to this document.

Upvotes: 1

Related Questions