News for hackers. Stuff that matters.
Re:Transitioning Google Cloud leadership after three great y... by WestCoastJustin on Friday November 16, 2018 @06:33PM (#18472845)
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-big...

[2] https://medium.com/google-cloud/visualize-gcp-billing-using-...

Re:Transitioning Google Cloud leadership after three great y... by chimerasaurus on Friday November 16, 2018 @07:10PM (#18472996)
I 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-mana...