By Vishal Bulbule．Jan 12, 2023
This article will show how we can create looker dashboard to analyse google cloud billing for each resources,projects etc.
Google Cloud Billing Export
In organization based project it is difficult to provide access to billing details for larger audience but still based on requirement we should have option to provide billing data to different team for analysis or for business.
Cloud Billing export to BigQuery enables you to export detailed Google Cloud billing data (such as usage, cost estimates, and pricing data) automatically throughout the day to a BigQuery dataset that you specify. Then you can access your Cloud Billing data from BigQuery for detailed analysis, or use a tool like Looker Studio to visualize your data.
Enable billing export to bigquery from Billing >> Billing Export tab
Verify data is being loaded into BigQuery dataset and tables.
Execute Sample Queries in BigQuery
Now Open Looker Studio > Blank report
Select BigQuery as datasource
Select correct project > Dataset > Table where billing data is exported
Create dashboard as per requirement including table,charts bar etc.
Publish your Dashboards.
Refer below Video for Demo
The original article published on Medium.