Build and Optimize Data Warehouses with BigQuery: Challenge Lab

This challenge labs tests your skills in building and optimizing your data warehouse using BigQuery.

• GSP340
• Overview
• Challenge scenario
• Task 1. Create a table partitioned by date
• Task 2. Add new columns to your table
• Task 3. Add country population data to the population column
• Task 4. Add country area data to the country_area column
• Task 5. Populate the mobility record data
• Task 6. Query missing data in population & country_area columns
• Tips and tricks
• Congratulations!