Query: storage_bucket_compute_backend_bucket_detail

with compute_backend_bucket as (
  select
    id,
    name,
    creation_timestamp,
    location,
    bucket_name
  from
    gcp_compute_backend_bucket
), storage_bucket as (
  select
    id,
    name
  from
    gcp_storage_bucket
  where
    id = split_part($1, '/', 1)
    and project = split_part($1, '/', 2)
)
select
  c.id as "Backend Bucket ID",
  c.name as "Backend Bucket Name",
  c.creation_timestamp as "Created Time",
  c.location as "Location"
from
  storage_bucket b,
  compute_backend_bucket c
where
  b.name = c.bucket_name;