Change default expiration time for a dataset.

0 votes
I want to change the default expiration time for a dataset. What's the way to do it?
Nov 15, 2019 in GCP by anonymous
• 6,260 points
197 views

1 answer to this question.

0 votes

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.

answered Nov 15, 2019 by Sirajul
• 58,130 points

Related Questions In GCP

+1 vote
1 answer

How do I change the default storage class of a bucket?

Use the gsutil defstorageclass set command: gsutil defstorageclass set [STORAGE_CLASS] ...READ MORE

answered Oct 25, 2019 in GCP by Sirajul
• 58,130 points
110 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
2 answers
0 votes
1 answer

Assign access control to a BigQuery Dataset.

You can apply access controls during dataset creation by ...READ MORE

answered Nov 15, 2019 in GCP by Sirajul
• 58,130 points
409 views
0 votes
1 answer

Permissions required to update a dataset.

At a minimum, to update dataset properties, ...READ MORE

answered Nov 15, 2019 in GCP by Sirajul
• 58,130 points
230 views
0 votes
1 answer

Using a JSON Schema file in BigQuery for creating a Schema.

After creating your JSON schema file, you ...READ MORE

answered Nov 15, 2019 in GCP by Sirajul
• 58,130 points
1,594 views
0 votes
1 answer

Default session timeout for a java app engine

Default session timeout is set to 30 ...READ MORE

answered Sep 25, 2019 in GCP by Sirajul
• 58,130 points
398 views
+1 vote
1 answer