cost_by_account_dashboard_account_costscost_by_account_dashboard_accounts_inputcost_by_account_dashboard_monthly_costcost_by_account_dashboard_total_accountscost_by_account_dashboard_total_costcost_by_region_dashboard_accounts_inputcost_by_region_dashboard_monthly_costcost_by_region_dashboard_region_costscost_by_region_dashboard_top_10_regionscost_by_region_dashboard_total_accountscost_by_region_dashboard_total_costcost_by_region_dashboard_total_regionscost_by_service_dashboard_accounts_inputcost_by_service_dashboard_monthly_costcost_by_service_dashboard_service_costscost_by_service_dashboard_top_10_servicescost_by_service_dashboard_total_accountscost_by_service_dashboard_total_costcost_by_service_dashboard_total_servicescost_by_tag_dashboard_accounts_inputcost_by_tag_dashboard_monthly_costcost_by_tag_dashboard_tag_key_inputcost_by_tag_dashboard_tag_value_costscost_by_tag_dashboard_top_10_tag_valuescost_by_tag_dashboard_total_accountscost_by_tag_dashboard_total_costoverview_dashboard_accounts_inputoverview_dashboard_daily_costoverview_dashboard_monthly_costoverview_dashboard_top_10_accountsoverview_dashboard_top_10_regionsoverview_dashboard_top_10_resourcesoverview_dashboard_top_10_servicesoverview_dashboard_total_accountsoverview_dashboard_total_cost
Query: overview_dashboard_top_10_regions
Usage
powerpipe query aws_cost_and_usage_insights.query.overview_dashboard_top_10_regionsTags
SQL
select coalesce(product_region_code, 'global') as "Region", round(sum(line_item_unblended_cost), 2) as "Total Cost"from aws_cost_and_usage_reportwhere ('all' in ($1) or line_item_usage_account_id in $1)group by "Region"order by "Total Cost" desclimit 10;
Params
| Args | Name | Default | Description | Variable |
|---|---|---|---|---|
| $1 | account_ids |
Dashboards
The query is used in the dashboards: