turbot/aws_insights

Query: acm_certificates_for_cloudfront_distribution

Usage

powerpipe query aws_insights.query.acm_certificates_for_cloudfront_distribution

SQL

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);