CODEWITHSUNDEEP
google-bigquery
None
None

Reputation: 281

How to change a dataset name

I created a dataset in BigQuery. Unfortunately, it is unclear how to rename it? I clicked on the arrow in the right side of the dataset name, but I can not see any option to rename it.

Upvotes: 0

Views: 2349

Answers (1)

Armin_SC
Armin_SC

Reputation: 2260

It is not possible to rename a dataset when using in BigQuery. Instead, it it required to recreate the resource and copy the old information into the new dataset, as mentioned in the public documentation.

Currently, you cannot change the name of an existing dataset, and you cannot copy a dataset and give it a new name. If you need to change the dataset name, follow these steps to recreate the dataset:

  1. Create a new dataset and specify the new name.
  2. Copy the tables from the old dataset to the new one.
  3. Recreate the views in the new dataset.
  4. Delete the old dataset to avoid additional storage costs.

Upvotes: 2

Related Questions