Query: redshift_cluster_publicly_accessible_table

select
   c.cluster_identifier as "Cluster Identifier",
   case when publicly_accessible then 'Public' else 'Not public' end as "Public Access State",
   c.cluster_status as "Cluster Status",
   a.title as "Account",
   c.account_id as "Account ID",
   c.region as "Region",
   c.arn as "ARN"
 from
   aws_redshift_cluster as c,
   aws_account as a
 where
   c.account_id = a.account_id
 order by
   c.cluster_identifier;