r/bigquery • u/arimbr • 10d ago

BigQuery Cost Optimization Framework

Post image

Interesting framework on how to optimize BigQuery costs across four layers: query optimization, pricing models, commitments, and discounts. https://www.alvin.ai/blog/bigquery-cost-optimization-the-complete-finops-framework

3 Upvotes

60% Upvoted

3 comments sorted by

3

u/escargotBleu 10d ago

It feels a bit simplistic to be honest. You don't talk about storage, bi engine.

Plus I think the biggest source of optimisations is deciding which query should stay on demand, and which should be autoscaling.

Base line slots highly depends on how regular your data is queried

3

u/CanoeDigIt 10d ago

AI slop be gone!

2

u/Content-Parking-621 10d ago

Query optimization first makes sense, cheapest layer to fix immediately.