Change default expiration time for a dataset

Question

I want to change the default expiration time for a dataset. What's the way to do it?

Answer 1

You can update a dataset's default table expiration time by:

• Using the GCP Console or the classic BigQuery web UI

• Using the bq update CLI command

• Calling the datasets.patch API method

• Using the client libraries

To Update a dataset using console:

1. In the Resources pane, select your dataset.

2. In the Details page, click the pencil icon next to Dataset info to edit the expiration.

3. In the Dataset info dialog, in the Default table expiration section, enter a value for Number of days after table creation.

4. Click Save.