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
• 5,840 points
107 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
• 54,240 points

Related Questions In GCP

0 votes
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
• 54,240 points
59 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

How do I create a BigQuery Dataset using the console?

To create a dataset: Open the BigQuery web ...READ MORE

answered Nov 15, 2019 in GCP by anonymous
• 54,240 points
66 views
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
• 54,240 points
282 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
• 54,240 points
148 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
• 54,240 points
1,103 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
• 54,240 points
289 views
0 votes
1 answer