Query: acm_certificates_for_cloudfront_distribution

select
  viewer_certificate ->> 'ACMCertificateArn' as certificate_arn
from
  aws_cloudfront_distribution
where
  viewer_certificate ->> 'ACMCertificateArn' is not null
  and arn = $1
  and account_id = split_part($1,':',5);