Query: storage_bucket_age_table

select
  b.name as "Name",
  b.id as "ID",
  now() :: date - b.time_created :: date as "Age in Days",
  b.time_created as "Create Time",
  p.name as "Project",
  p.project_id as "Project ID",
  b.location as "Location",
  b.self_link as "Self-Link"
from
  gcp_storage_bucket as b,
  gcp_project as p
where
  p.project_id = b.project
order by
  b.time_created,
  b.name;