Query: cloudfront_distributions_for_acm_certificate

select
  arn as distribution_arn
from
  aws_cloudfront_distribution
where
  arn in (
    select
      jsonb_array_elements_text(in_use_by)
    from
      aws_acm_certificate
    where
      certificate_arn = $1
  );