Summary
Designing and organizing your BigQuery data is an important part of using BigQuery effectively. In this chapter, we outlined Google Cloud’s resource hierarchy and BigQuery resources and provided best practices for each feature. This chapter’s diagrams were built upon as the chapter progressed, providing a visual approach to understanding BigQuery resources, design, and organization.
In conclusion, designing and organizing a BigQuery environment requires a good understanding of resources and consideration of several key factors, including pattern and schema design. By following the best practices in this chapter, you can create a data warehouse that is easy to query and analyze, cost-effective, and performant. In the next chapter, we will shift to exploring data. Read on to learn about the various tools and approaches to continue to build your data analysis skillset.
