turbot/aws_insights

Query: s3_bucket_public_access_table

Usage

powerpipe query aws_insights.query.s3_bucket_public_access_table

Steampipe Tables

SQL

select
b.name as "Name",
case when b.bucket_policy_is_public then 'Public' else 'Not public' end as "Bucket Policy Public",
case when b.block_public_acls then 'Enabled' else null end as "Block Public ACLs",
case when b.block_public_policy then 'Enabled' else null end as "Block Public Policy",
case when b.ignore_public_acls then 'Enabled' else null end as "Ignore Public ACLs",
case when b.restrict_public_buckets then 'Enabled' else null end as "Restrict Public Buckets",
a.title as "Account",
b.account_id as "Account ID",
b.region as "Region",
b.arn as "ARN"
from
aws_s3_bucket as b,
aws_account as a
where
b.account_id = a.account_id
order by
b.name;

Dashboards

The query is used in the dashboards: