How to retrieve Project ID, Dataset ID, and Location ID in Google BigQuery

To access your Google BigQuery information, such as Project ID, Dataset ID, and Dataset Location ID, please navigate to the Google Cloud Console BigQuery interface at BigQuery Studio.

Finding Project ID

The Project ID is a part of the URL (project parameter) when you're navigating through your project's resources. It also appears in the dropdown on the top navbar and on the left sidebar under the "Explorer" panel.

For example https://console.cloud.google.com/bigquery?project=jdp-studio
Project ID : jdp-studio

1

Finding Dataset Name

After selecting your project in the BigQuery console, navigate to the "Explorer" panel. Here, datasets are listed under their respective projects.

Method A.

Click on the Dataset Name and a panel will open on the left. Dataset Name is the name next to the Project ID.

For example in this case
Dataset Name : demo_data_1

2

Finding Dataset ID & Location ID

After selecting your project in the BigQuery console, navigate to the "Explorer" panel. Here, datasets are listed under their respective projects.

Method A.

Click on 3 dots next to the Dataset Name and select Copy ID.

For example in this case
Dataset ID : jdp-studio.demo_data_1

4


Method B.

Click on any Dataset and the "Dataset info" tab will open on the right. There you can find Dataset ID along with Data Location which indicates where your data is stored geographically (e.g., US, EU).

For example in this case
Dataset ID : jdp-studio.demo_data_1, Data Location : EU

3