Query: ec2_network_interface_association_details

select
  eni.association_allocation_id "Allocation ID",
  eni.association_public_ip as "Public IP Address",
  eni.association_carrier_ip as "Carrier IP",
  eni.association_customer_owned_ip as "Customer Owned IP",
  eni.association_id as "Association ID",
  eni.association_ip_owner_id as "IP Owner ID",
  eni.association_public_dns_name as "Public DNS Name",
  eip_alloc.arn as "EIP Alloc ARN"
from
  aws_ec2_network_interface eni
  left join aws_vpc_eip eip_alloc on eip_alloc.allocation_id = eni.association_allocation_id
  and eip_alloc.association_id = eni.association_id
where
  eni.network_interface_id = $1
  and eni.association_allocation_id is not null;