Dashboard: GCP Cloud Billing Report: Cost by Location

This dashboard answers the following questions:

What is the total cost across all locations?
How has the cost trended monthly by location?
Which locations incurred the highest costs?
What are the detailed costs by location across projects?

This dashboard contains 4 cards, 1 input and 1 table.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe 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 Location dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run gcp_cloud_billing_insights.dashboard.cloud_billing_report_cost_by_location_dashboard --share

Queries

This dashboard uses the the following queries:

select
  project_id as "Project",
  coalesce(location.region, 'global') as "Location",
  location.zone as "Zone",
  round(sum(cost), 2) as "Total Cost",
  currency as "Currency"
from
  gcp_billing_report
where
  ('all' in ($1) or project_id in $1)
group by
  project_id,
  project_name,
  location.region,
  location.zone,
  currency
order by
  sum(cost) desc;

{
  "$1": "project_ids"
}

Dashboard: GCP Cloud Billing Report: Cost by Location

Usage

Queries

Tags