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_cost_by_location_dashboard_total_locations
Usage
powerpipe query gcp_cloud_billing_insights.query.cloud_billing_report_cost_by_location_dashboard_total_locationsSQL
select 'Locations' as label, count(distinct coalesce(location.region, 'global')) as valuefrom gcp_billing_reportwhere ('all' in ($1) or project_id in $1);
Params
| Args | Name | Default | Description | Variable |
|---|---|---|---|---|
| $1 | project_ids |
Dashboards
The query is used in the dashboards: