Control: Compute Backend Bucket should not have dangling storage bucket

powerpipe control run gcp_compliance.control.compute_backend_bucket_no_dangling_storage_bucket

powerpipe login
powerpipe control run gcp_compliance.control.compute_backend_bucket_no_dangling_storage_bucket --share

select
  b.self_link resource,
  case
    when s.name is not null then 'ok'
    else 'alarm'
  end as status,
  case
    when s.name is not null then b.title || ' has no dangling storage bucket.'
    else b.title || ' has dangling storage bucket.'
  end as reason
  
  , b.location as location, b.project as project
from
  gcp_compute_backend_bucket as b
  left join gcp_storage_bucket as s on s.name = b.name and s.project = b.project;