Query: storage_bucket_uniform_bucket_level_access_status

with buckets as (
  select
    case
      when iam_configuration_uniform_bucket_level_access_enabled then 'enabled'
      else 'disabled'
    end as bucket_access_status
  from
    gcp_storage_bucket
)
select
  bucket_access_status,
  count(*)
from
  buckets
group by
  bucket_access_status;