Introduction to Google BigQuery

This file contains text you can copy and paste for the examples in Cloud Academy's Introduction to Google BigQuery course.

Running a Query

SELECT *
FROM
 `bigquery-public-data.usa_names.usa_1910_2013`
ORDER BY number DESC LIMIT 10

SELECT *
FROM
 `bigquery-public-data.usa_names.usa_1910_2013`
WHERE gender = 'F'
ORDER BY number DESC LIMIT 10

Loading Data

Baby names data
Jeopardy data
Google Cloud SDK installation instructions

bq mk public
bq load --autodetect public.jeopardy JEOPARDY_CSV.csv

Exporting Data

bq extract

gs://ca-example/games*.csv.gz

Conclusion

BigQuery documentation
[email protected]