Tips for managing BigQuery costs

Support Self Hosted Redash Support
1

Issue Summary

We are seeing rapidly increasing BigQuery costs. Costs went form 0 to thousands per month after we started using dashboards. Do you have any recommendations on cost management or ways to deep dive on costs to identify savings?

Technical details:

  • Redash Version: 8.0.0 (dev)
  • Browser/OS: Chrome
  • How did you install Redash: Self-installed
2

Apart from the obvious stuff Control costs in BigQuery  |  Google Cloud (for example do not use select *)?

Maybe users have the refresh button? You can also rely on the ‘share dashboard’ link and let people use that. If you share dashboards that way, they can not refresh anymore.

All that is left then is use the scheduler for updating the query (for example just once per day or something like that)