Google Cloud Platform for Architects

Working with the BigQuery console

BigQuery can be accessed using both GUI and command line. To access BigQuery using a GUI console:

1. Click on the menu button on the top-left corner of the console and select BigQuery from the drop-down menu. You will encounter a new console looking something like this:

2. Click on the COMPOSE QUERY button to enable the text area where queries can be written:

3. To query a public dataset, paste the following text into the text area:

#standardSQL SELECT weight_pounds, state, year, gestation_weeks FROM `bigquery-public-data.samples.natality` ...