Query: s3_bucket_public_access_table

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;