Query: ec2_application_load_balancers_for_acm_certificate

with certificate_usage as (
  select
    jsonb_array_elements_text(in_use_by) as in_use_arn
  from
    aws_acm_certificate
  where
    account_id = split_part($1, ':', 5)
    and region = split_part($1, ':', 4)
    and certificate_arn = $1
)
select
  alb.arn as alb_arn
from
  aws_ec2_application_load_balancer alb
join
  certificate_usage cu on alb.arn = cu.in_use_arn;