Skip to content

Latest commit

 

History

History
38 lines (34 loc) · 926 Bytes

README.md

File metadata and controls

38 lines (34 loc) · 926 Bytes

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]