Technical requirements
As mentioned in Chapter 1, to get the most out of this chapter, you will want to have access to the Google Cloud console (https://console.cloud.google.com/) to explore and build resources in BigQuery. You can also begin exploring the GitHub repository https://github.com/PacktPublishing/Data-Exploration-and-Preparation-with-BigQuery for this book to browse and download diagrams and code snippets.
In this chapter, we utilize a dataset made accessible through the Google Cloud Public Datasets Program. These datasets are hosted and maintained by Google, ensuring their availability to the public. You only incur charges for the specific queries you execute on the data, as Google covers the storage costs.
Add the Google Trends dataset to your Google Cloud project for hands-on examples. You can find the Google Trends dataset at https://cloud.google.com/datasets, and clicking View Dataset will bring the dataset into your SQL workspace in BigQuery. You can favorite...