GCP Cloud Billing Report: Cost by LabelGCP Cloud Billing Report: Cost by LocationGCP Cloud Billing Report: Cost by ProjectGCP Cloud Billing Report: Cost by ServiceGCP Cloud Billing Report: Overview
Dashboard: GCP Cloud Billing Report: Cost by Service
This dashboard answers the following questions:
- What is the total cost across all services?
- How has the cost trended monthly by service?
- Which services incurred the highest costs?
- What are the detailed costs by service across projects?
This dashboard contains 3 cards, 1 input and 1 table.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/tailpipe-mod-gcp-cloud-billing-insights
Start the Powerpipe server:
powerpipe server
Open http://localhost:9033 in your browser and select GCP Cloud Billing Report: Cost by Service dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe dashboard run gcp_cloud_billing_insights.dashboard.cloud_billing_report_cost_by_service_dashboard --share
Queries
This dashboard uses the the following queries:
select strftime(date_trunc('month', usage_start_time), '%b %Y') as "Month", service_description as "Service", round(sum(cost), 2) as "Total Cost"from gcp_billing_reportwhere ('all' in ($1) or project_id in $1)group by date_trunc('month', usage_start_time), service_descriptionorder by date_trunc('month', usage_start_time), sum(cost) desc;
{ "$1": "project_ids"}