turbot/aws_insights

Query: s3_bucket_public_access_blocked

Usage

powerpipe query aws_insights.query.s3_bucket_public_access_blocked

Steampipe Tables

SQL

with public_block_status as (
select
case
when
block_public_acls
and block_public_policy
and ignore_public_acls
and restrict_public_buckets
then 'blocked' else 'not blocked'
end as block_status
from
aws_s3_bucket
)
select
block_status,
count(*)
from
public_block_status
group by
block_status;

Dashboards

The query is used in the dashboards: