I'll be walking you through how to set up Google Cloud Platform Billing Export with BigQuery to help you manage and have more insight into your cloud invoice.
If you manage Billing at your company or have different side projects you definitely want to be able to manage, analyze, and optimize your cloud costs to fit your company/personal budget. If you're just experimenting with GCP, then it's just something to learn!
This is the Dataset that the Billing data will be streamed into
- Dataset ID: Can be whatever - 'Billing' works
- Data Location: Default is fine
- Table Expiration: For this walkthrough 2 days is fine, you probably wouldn't want it ever expiring though
- Encryption: Google-managed key is fine
You now have a Dataset set up for your Billing data to be streamed into!
Note: If you don't see text that says 'Disabled' then you already have the Billing Export feature activated. So you just need to know the Dataset that it's streaming into and check it out.
Google mentions that it might take a few hours before the data starts streaming into the table, but there's nothing else to do from your end other than wait.
The Dataset that Google creates and streams for you is really detailed and they're constantly making updates so that you can gain more insight into your costs and a breakdown of those costs down to the penny. This Dataset can be drilled down and analyzed by project or service and can even show you how much of your costs are in taxes. All you need to do is be creative with your queries.
Twitter - @jsrioss
Github - @juanri0s