turbot/aws_insights

Query: dynamodb_table_item_count_by_account

Usage

powerpipe query aws_insights.query.dynamodb_table_item_count_by_account

SQL

select
a.title as "Account",
sum(t.item_count) as "Count"
from
aws_dynamodb_table as t,
aws_account as a
where
a.account_id = t.account_id
group by
a.title
order by
a.title;

Dashboards

The query is used in the dashboards: