Summary

Google Cloud provides intelligent recommendations and service features in BigQuery to enable you to operate a modern data warehouse cost-effectively. With its free tier, you can store and process data at no cost, and with BigQuery Editions, you can take advantage of capacity-based pricing for business-critical data analytics workloads. In this chapter, we went over various methods for preparing and optimizing data and provided best practices for cost-effectively using BigQuery.

By taking advantage of ML recommendations based on your specific workloads, rich SQL functions and capabilities, and thoughtful setup and regular querying practices, you can run a highly efficient data warehouse to unlock insights at any usage level. In the next chapter, we will start covering this book’s end-to-end use cases with advertising data.