Query: acm_certificate_validity

select
  case
    when not_after is null
    or not_after < now() then 'Invalid'
    else 'Valid'
  end as value,
  'Validity' as label,
  case
    when not_after is null
    or not_after < now() then 'alert'
    else 'ok'
  end as type
from
  aws_acm_certificate
where
  certificate_arn = $1;