Query: kms_key_age

select
  creation_date as "Creation Date",
  deletion_date as "Deletion Date",
  extract(day from deletion_date - current_date)::int as "Deleting After Days"
from
  aws_kms_key
where
  arn = $1
  and region = split_part($1, ':', 4)
  and account_id = split_part($1, ':', 5);