sp26-cs544 cs544
Lecture 40: BigQuery 4: Cost and Performance Lecture 40: BigQuery 4: Cost and Performance
Content locked
The catalog is public. Reading this content requires approved access.
Sign in to readLecture 40: BigQuery 4: Cost and Performance
Overview
Learning Objectives
Billing Models
Resources
BigQuery Slots
Billing Model 1: Capacity Pricing (compute-based)
Billing Model 2: On-Demand Pricing (I/O-based)
Comparison
Estimating and Capping On-Demand Costs
Note on Confusing Billing Terminology
Optimization
Partitioning
Clustering
Maintenance: Clustered vs. Unclustered Regions
Partitioning vs. Clustering
Conclusion
Source