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

Query: cloud_billing_report_cost_by_project_dashboard_project_costs

Usage

powerpipe query gcp_cloud_billing_insights.query.cloud_billing_report_cost_by_project_dashboard_project_costs

SQL

select
project_name as "Project",
round(sum(cost), 2) as "Total Cost"
from
gcp_billing_report
where
('all' in ($1) or project_id in $1)
group by
project_name
order by
sum(cost) desc;

Params

ArgsNameDefaultDescriptionVariable
$1project_ids

    Dashboards

    The query is used in the dashboards: