Selecting a BigQuery public dataset
Google Career Certificates
9 steps
44 seconds
Google Cloud
Make sure you are logged in to your BigQuery account. In your browser, go to [console.cloud.google.com/bigquery](http://console.cloud.google.com/bigquery).
1
Click ADD DATA in the Explorer.
2
Select Explore public datasets.
3
You can search for a dataset by topic; for example, you can enter bike share in the search bar to get the results below. Click a dataset for additional details.
4
Click VIEW DATASET.
5
Click QUERY TABLE to get started.
6
Modify the query to specify what you want to run. If you add * between SELECT and FROM, the query will return data from all columns in the data table.
7
After you add * after SELECT, click RUN to run the query.
8
You can drag the results pane up to resize it and see more results.
9
The results from the query are in the Results tab. Click the Job Information, JSON, and Execution details tabs to view other information related to the query.
Selecting a BigQuery public dataset
Google Career Certificates
9 steps
44 seconds
Google Cloud
Make sure you are logged in to your BigQuery account. In your browser, go to [console.cloud.google.com/bigquery](http://console.cloud.google.com/bigquery).
1
Click ADD DATA in the Explorer.
2
Select Explore public datasets.
3
You can search for a dataset by topic; for example, you can enter bike share in the search bar to get the results below. Click a dataset for additional details.
4
Click VIEW DATASET.
5
Click QUERY TABLE to get started.
6
Modify the query to specify what you want to run. If you add * between SELECT and FROM, the query will return data from all columns in the data table.
7
After you add * after SELECT, click RUN to run the query.
8
You can drag the results pane up to resize it and see more results.
9
The results from the query are in the Results tab. Click the Job Information, JSON, and Execution details tabs to view other information related to the query.
