How do I create a BigQuery Dataset using the console

Question

I want to create a dataset, how can I do this using the console?

Answer 1

To create a dataset:

1. Open the BigQuery web UI in the GCP Console.

2. In the navigation panel, in the Resources section, select your project.

3. On the right side of the window, in the details panel, click Create dataset.

4. On the Create dataset page:

   • For Dataset ID, enter a unique dataset name.

   • (Optional) For Data location, choose a geographic location for the dataset. If you leave the value set to Default, the location is set to US. After a dataset is created, the location can't be changed

   • For Default table expiration, choose one of the following options:

     • Never: (Default) Tables created in the dataset are never automatically deleted. You must delete them manually.

     • Number of days after table creation: This value determines when a newly created table in the dataset is deleted. This value is applied if you do not set a table expiration when the table is created.

   • Click Create dataset.

Answer 2

1. Open BigQuery

2. Select the project from the left pain

3. You will see the "CREATE DATASET" option for creating the dataset into the project you have selected

Regards

DD Lamani