Summary
In this chapter, we’ve practiced using BigQuery to build a data warehouse. In general, we’ve covered the three main aspects of how to use the tools, how to load the data to BigQuery, and the data modeling aspect of a data warehouse.
After following all the steps in this chapter, you will have a better understanding of the data life cycle and you will understand that data moves from place to place. We also practiced the ELT process in this chapter, extracting data from a MySQL database, loading it to BigQuery, and doing some transformations to answer business questions. And on top of that, we did it all on a fully managed service in the cloud, spending zero time worrying about any infrastructure aspects.
By way of a footnote for this chapter, I want to remind you that, even though we have covered the common practices of using BigQuery, we haven’t covered all of its features. There are a lot of other features in BigQuery that are worth checking out...
