cloud_billing_report_cost_by_label_dashboard_label_key_inputcloud_billing_report_cost_by_label_dashboard_label_value_costscloud_billing_report_cost_by_label_dashboard_monthly_costcloud_billing_report_cost_by_label_dashboard_projects_inputcloud_billing_report_cost_by_label_dashboard_top_10_label_valuescloud_billing_report_cost_by_label_dashboard_total_costcloud_billing_report_cost_by_label_dashboard_total_projectscloud_billing_report_cost_by_location_dashboard_location_costscloud_billing_report_cost_by_location_dashboard_monthly_costcloud_billing_report_cost_by_location_dashboard_projects_inputcloud_billing_report_cost_by_location_dashboard_top_10_locationscloud_billing_report_cost_by_location_dashboard_total_costcloud_billing_report_cost_by_location_dashboard_total_locationscloud_billing_report_cost_by_location_dashboard_total_projectscloud_billing_report_cost_by_location_dashboard_total_zonescloud_billing_report_cost_by_project_dashboard_monthly_costcloud_billing_report_cost_by_project_dashboard_project_costscloud_billing_report_cost_by_project_dashboard_projects_inputcloud_billing_report_cost_by_project_dashboard_total_costcloud_billing_report_cost_by_project_dashboard_total_projectscloud_billing_report_cost_by_service_dashboard_monthly_costcloud_billing_report_cost_by_service_dashboard_projects_inputcloud_billing_report_cost_by_service_dashboard_service_costscloud_billing_report_cost_by_service_dashboard_top_10_servicescloud_billing_report_cost_by_service_dashboard_total_costcloud_billing_report_cost_by_service_dashboard_total_projectscloud_billing_report_cost_by_service_dashboard_total_servicescloud_billing_report_overview_dashboard_daily_costcloud_billing_report_overview_dashboard_monthly_costcloud_billing_report_overview_dashboard_projects_inputcloud_billing_report_overview_dashboard_top_10_locationscloud_billing_report_overview_dashboard_top_10_projectscloud_billing_report_overview_dashboard_top_10_servicescloud_billing_report_overview_dashboard_total_costcloud_billing_report_overview_dashboard_total_projectscloud_billing_report_overview_dashboard_total_services
Query: cloud_billing_report_overview_dashboard_top_10_locations
Usage
powerpipe query gcp_cloud_billing_insights.query.cloud_billing_report_overview_dashboard_top_10_locationsSQL
select coalesce(location.region, 'global') as "Region", coalesce(location.zone, '-') as "Zone", round(sum(cost), 2) as "Total Cost"from gcp_billing_reportwhere ('all' in ($1) or project_id in $1)group by location.region, location.zoneorder by sum(cost) desclimit 10;
Params
| Args | Name | Default | Description | Variable |
|---|---|---|---|---|
| $1 | project_ids |
Dashboards
The query is used in the dashboards: