BigQuery excels at analyzing an organization’s custom data, but it also has built-in access to a great number of public datasets. Not only can these public datasets be useful in a business context, but they can also be helpful when one is familiarizing oneself with BigQuery operations and procedures. In this hands-on lab, you’ll query the Cloud-to-Ground Lightning Strikes dataset from the Department of Commerce agency, National Oceanic and Atmospheric Administration (NOAA), to find the date when the most lightning struck in a single day of a given year as well as where the most lightning strikes are located.
Successfully complete this lab by achieving the following learning objectives:
- Enable the Necessary APIs
Enable the BigQuery API, either through the user interface or the Cloud Shell.
- Connect to a Public Dataset
Identify and connect to the desired public dataset.
- Query the Dataset
Input and run the desired queries.