Query: route53_domain_expires_30_days

select
  arn as resource,
  case
    when date(expiration_date) - date(current_date) >= 30 then 'ok'
    else 'alarm'
  end as status,
    title || ' set to expire in ' || extract(day from expiration_date - current_date) || ' days.' as reason

  
  , region, account_id
from
  aws_route53_domain;