r/analyticsengineering 8d ago

Optimisation of bigquery for better performance cost for analytics

https://github.com/muchai322/BigQuery-Performance-Cost-Optimization-Security-Reliability
0 Upvotes

3 comments sorted by

2

u/dmkii 8d ago

Nice overview! Really great to get started with optimisation of costs. I think the one big thing I miss is the fact that you can use different projects for compute for different types of billing (on demand vs. editions) to optimize cost that way. Masthead has some interesting blogs on that (e.g. https://mastheadata.com/blog/google-bigquery-compute-cost-optimization) and they’re generally a great tool if you want continuous cost monitoring and observability for bigquery.

1

u/Slowmac123 8d ago

A topic i needed to read up on. Thx