Dashboard: GCP Cloud Billing Report: Overview

This dashboard answers the following questions:

What is the total cost across all projects?
How many projects and services are being used?
How have costs trended over time (daily and monthly)?
Which projects incurred the highest costs?
Which locations and services are the most expensive?

This dashboard contains 3 cards and 1 input.

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: Overview dashboard.

You could also snapshot and share results via Turbot Pipes:

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

Queries

This dashboard uses the the following queries:

select
  date_trunc('day', usage_start_time)::timestamp as "Date",
  round(sum(cost), 2) as "Total Cost"
from
  gcp_billing_report
where
  ('all' in ($1) or project_id in $1)
group by
  date_trunc('day', usage_start_time)
order by
  date_trunc('day', usage_start_time);

{
  "$1": "project_ids"
}

Dashboard: GCP Cloud Billing Report: Overview

Usage

Queries

Tags