Learning Google BigQuery

Querying public data

Analysts can begin by querying public data provided by Google. These datasets span a wide variety of subjects, such as the NYC Tree Census, Stack Overflow Question Data, and Chicago Crime Data. More information can be found at: https://cloud.google.com/bigquery/public-data/.

To navigate to the dataset, choose the Display Project option by opening the menu as shown here in the BigQuery web console screen:

Type the name of the project, as shown in this screenshot:

Let's start by querying the US census dataset:

1. Click on ...