Query: storage_bucket_public_access

select
  'Public Access' as label,
  case when iam_policy ->> 'bindings' like any (array ['%allAuthenticatedUsers%','%allUsers%']) then 'Enabled' else 'Disabled' end as value,
  case when iam_policy ->> 'bindings' like any (array ['%allAuthenticatedUsers%','%allUsers%']) then 'alert' else 'ok' end as type
from
  gcp_storage_bucket
where
  id = split_part($1, '/', 1)
  and project = split_part($1, '/', 2);