Optimizing Google BigQuery with Schema Design
Difficulty: Intermediate
Duration: 1 minute and 42 seconds
Students: 329
Rating: 5/5
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