Query: kms_key_age_table

select
  k.name as "Name",
  now() :: date - k.create_time :: date as "Age in Days",
  k.create_time as "Create Time",
  k.key_ring_name as "Key Ring Name",
  p.name as "Project",
  p.project_id as "Project ID",
  k.location as "Location",
  k.self_link as "Self-Link"
from
  gcp_kms_key as k,
  gcp_project as p
where
  p.project_id = k.project
order by
  k.create_time,
  k.name;