Query: storage_bucket_logging_status

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