Query: storage_bucket_retention_policy_status

with buckets as (
  select
    case
      when retention_policy is null then 'disabled'
      else 'enabled'
    end as retention_policy_status
  from
    gcp_storage_bucket
)
select
  retention_policy_status,
  count(*)
from
  buckets
group by
  retention_policy_status;