Query: ec2_network_load_balancers_for_ec2_instance

select
  distinct lb.arn as network_load_balancer_arn
from
  aws_ec2_instance as i,
  aws_ec2_target_group as target,
  jsonb_array_elements(target.target_health_descriptions) as health_descriptions,
  jsonb_array_elements_text(target.load_balancer_arns) as l,
  aws_ec2_network_load_balancer as lb
where
  health_descriptions -> 'Target' ->> 'Id' = i.instance_id
  and l = lb.arn
  and i.arn = $1;