Creating Date-Partitioned Tables in BigQuery

This lab focuses on how to query partitioned datasets and how to create your own dataset partitions to improve query performance, which reduces cost.

• GSP414
• Overview
• Setup and requirements
• Task 1. Create a new dataset
• Task 2. Creating tables with date partitions
• Task 3. View data processed with a partitioned table
• Task 4. Creating an auto-expiring partitioned table
• Task 5. Your turn: create a partitioned table
• Task 6. Confirm the oldest partition_age is at or below 60 days
• Congratulations!