Optimizing Google BigQuery with Schema Design

Difficulty: Intermediate
Duration: 1 minute and 42 seconds
Students: 331
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