Query: storage_bucket_versioning_status

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