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
  account_id = split_part($1, ':', 5)
  and region = split_part($1, ':', 4)
  and certificate_arn = $1;