turbot/aws_insights

Query: dynamodb_table_unused_status

Usage

powerpipe query aws_insights.query.dynamodb_table_unused_status

Steampipe Tables

SQL

with table_status as (
select
name,
case
when item_count > 0 then 'in-use'
else 'unused'
end as table_usage_status
from
aws_dynamodb_table
)
select
table_usage_status,
count(*) as table_count
from
table_status
group by table_usage_status;

Dashboards

The query is used in the dashboards: