turbot/tailpipe-mod-gcp-cloud-billing-insights

Query: cloud_billing_report_overview_dashboard_monthly_cost

Usage

powerpipe query gcp_cloud_billing_insights.query.cloud_billing_report_overview_dashboard_monthly_cost

SQL

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

Params

ArgsNameDefaultDescriptionVariable
$1project_ids

    Dashboards

    The query is used in the dashboards: