Query: redshift_cluster_by_publicly_accessible_status

select
  publicly_accessible_status,
  count(*)
from
  (
    select
      publicly_accessible,
      case
        when publicly_accessible then 'public'
        else 'private'
      end publicly_accessible_status
    from
      aws_redshift_cluster
  ) as t
group by
  publicly_accessible_status
order by
  publicly_accessible_status desc;