Optimizing Google BigQuery with Schema Design
BigQuery is Google's incredibly fast and surprisingly inexpensive data warehouse. In this lesson, we will look at how to best optimize your table schemas to make it run even faster and cheaper.
Learning Objectives
- Denormalize your BigQuery tables for better performance
- Reduce data duplication by using nested and repeated fields
- Partition your tables to lower your query costs
- Cluster your tables to improve the query execution time
Intended Audience
- Database Administrators
- Data Engineers
- Data Analysts
- Anyone preparing for a Google Cloud certification
Prerequisites
- Familiar with BigQuery
- Comfortable with SQL syntax
- Access to a GCP account
Daniel began his career as a Software Engineer, focusing mostly on web and mobile development. After twenty years of dealing with insufficient training and fragmented documentation, he decided to use his extensive experience to help the next generation of engineers.
Daniel has spent his most recent years designing and running technical classes for both Amazon and Microsoft. Today at Cloud Academy, he is working on building out an extensive Google Cloud training library.
When he isn’t working or tinkering in his home lab, Daniel enjoys BBQing, target shooting, and watching classic movies.