WORKSHOP
BigQuery Cost Management
BigQuery costs can be hard to tackle and keep under control, we know. With a specific type of engine and billing, costs can creep up quickly. Join us for a workshop to discover how we deal with this problem at Adore Me and leave with some helpful tips on how to set up your own cost management system for BigQuery.
Summary
Intro
- Why BigQuery?
- How BigQuery works
- Column processing vs row processing
- Pros and cons
- Case study: GA4 data
- Overview on why this was chosen as an example
Elements of Cost Management
- Components of cost calculation
- Cost monitoring
- Resources for Cost Monitoring
- Setting thresholds
Analysis Side
- Views vs Scheduled queries
- Select *
- View layering
- Pitfalls of Data Studio
Dev Side
- Partitioning
- Aggregation methods
- Delete/Insert vs Merge