turbot/tailpipe-mod-aws-cost-usage-report-insights

Query: cost_by_account_dashboard_total_cost

Usage

powerpipe query aws_cost_and_usage_insights.query.cost_by_account_dashboard_total_cost

SQL

select
'Total Cost (' || line_item_currency_code || ')' as label,
round(sum(line_item_unblended_cost), 2) as value
from
aws_cost_and_usage_report
where
('all' in ($1) or line_item_usage_account_id in $1)
group by
line_item_currency_code
limit 1;

Params

ArgsNameDefaultDescriptionVariable
$1account_ids

    Dashboards

    The query is used in the dashboards: