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 on the left sidebar under the "Explorer" panel.

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

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

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

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