Table: aws_nat_gateway

select
  nat_gateway_id,
  address ->> 'PrivateIp' as private_ip,
  address ->> 'PublicIp' as public_ip,
  address ->> 'NetworkInterfaceId' as nic_id,
  address ->> 'AllocationId' as allocation_id
from
  aws_vpc_nat_gateway
  cross join jsonb_array_elements(nat_gateway_addresses) as address;

select
  nat_gateway_id,
  vpc_id,
  subnet_id
from
  aws_vpc_nat_gateway;

select
  nat_gateway_id,
  tags
from
  aws_vpc_nat_gateway
where
  not tags :: JSONB ? 'application';

select
  vpc_id,
  count(nat_gateway_id) as nat_gateway_id
from
  aws_vpc_nat_gateway
group by
  vpc_id;