3 ms·
For anyone else who is a Google Cloud Customer. I 100% recommend "Exporting Billing Data to BigQuery" [1]. This takes less than 5 minutes and will give you near
by WestCoastJustin 8y ago
For anyone else who is a Google Cloud Customer. I 100% recommend "Exporting Billing Data to BigQuery" [1]. This takes less than 5 minutes and will give you near real-time extremely detailed billing data into BQ where you can explore it via SQL. Second, generate a real-time report off this data with something like "Visualize GCP Billing using BigQuery and Data Studio" [2].
That blog post is good, but it is over built in my opinion, all you really need is a single daily sum of all spend across your account and chart that. Maybe a stacked column with product color or something. This will allow you to quickly see if one product consumption is shooting up unexpectedly at a glance vs checking something at the end of the month and working with your account reps to figure something out.
6k z z
5k z z
spend 4k z z z
3k z z z
2k x x x x x x x x x
1k x x x x x x x x x
date 1 2 3 4 5 6 7 8 d+
x = expected
z = unexpected
For example, maybe you left a test env running or something and all of the sudden you're spending an extra few K per day. Maybe you're doing some query loops over a large BQ dataset and racking up tons of $$. Put the chart up on your big TV screen in the Ops area so everyone can quickly check it with all your other metrics. When you're spending 100k+/month, with a few folks digging around the console, it's hard to notice an extra 5k-10k here or there. This quick tip will totally help you visually sanity check if something is off. So, this might not be a killer solution for folks spending a few thousand a month but will totally saves tens of thousands as you scale up.
[1] https://cloud.google.com/billing/docs/how-to/export-data-bigquery https://cloud.google.com/billing/docs/how-to/export-data-big...
[2] https://medium.com/google-cloud/visualize-gcp-billing-using-bigquery-and-data-studio-d3e695f90c08 https://medium.com/google-cloud/visualize-gcp-billing-using-...
- chimerasaurus 8y agoI also highly recommend using labels[1] with billing data to get a better understanding of spend. 1: https://cloud.google.com/resource-manager/docs/creating-managing-labels https://cloud.google.com/resource-manager/docs/creating-mana...