BigQuery for Data Warehousing: Managed Data Analysis in the Google Cloud

© Mark Mucchetti 2020

M. MucchettiBigQuery for Data Warehousinghttps://doi.org/10.1007/978-1-4842-6186-6_20

20. Jupyter Notebooks and Public Datasets

Mark Mucchetti¹ 

(1)

Santa Monica, CA, USA

 

One of BigQuery’s advantages is its ability to query into external datasets. We’ve mostly used this capability for federated queries to your data hosted in other Google Cloud Platform services or as a stepping stone to loading that data into your own warehouse. Google hosts several hundred public datasets through its Google BigQuery Public Datasets program.¹ Google’s available data crosses a wide variety of disciplines and includes datasets like the National Oceanic and Atmospheric Administration’s daily weather records with some data going back as early as ...