Query: storage_bucket_logging_detail

select
  b.log_bucket as "Log Bucket",
  b.log_object_prefix as "Log Object Prefix",
  l.create_time as "Created Time",
  l.retention_days as "Retention Days",
  l.lifecycle_state as "Lifecycle State"
from
  gcp_storage_bucket b,
  gcp_logging_bucket l
where
  b.id = $1
  and b.log_bucket is not null
  and b.log_bucket = l.name;