turbot/aws_insights

Query: s3_bucket_by_account

Usage

powerpipe query aws_insights.query.s3_bucket_by_account

Steampipe Tables

SQL

select
a.title as "Account",
count(i.*) as "total"
from
aws_s3_bucket as i,
aws_account as a
where
a.account_id = i.account_id
group by
a.title
order by
count(i.*) desc;

Dashboards

The query is used in the dashboards: