Query: ebs_snapshot_by_public_status

with public_status as (
  select
    case when create_volume_permissions @> '[{"Group": "all"}]' then
      'public'
    else
      'private'
    end as visibility
  from aws_ebs_snapshot
)
select
  visibility,
  count(*)
from
  public_status
group by
  visibility;