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

Query: cloud_billing_report_cost_by_project_dashboard_total_cost

Usage

powerpipe query gcp_cloud_billing_insights.query.cloud_billing_report_cost_by_project_dashboard_total_cost

SQL

select
'Total Cost (' || currency || ')' as label,
round(sum(cost), 2) as value
from
gcp_billing_report
where
('all' in ($1) or project_id in $1)
group by
currency
limit 1;

Params

ArgsNameDefaultDescriptionVariable
$1project_ids

    Dashboards

    The query is used in the dashboards: