NAT gateways are enterprise-class gateways that provide the Source Network Address Translation (SNAT) and Destination Network Address Translation (DNAT) features. Each NAT gateway provides a throughput capacity of up to 10 Gbit/s. NAT gateways also support cross-zone disaster recovery.
Explore the status and billing method of your Alibaba Cloud Virtual Private Cloud (VPC) NAT gateways. This is useful for understanding the operational status and cost management of your NAT gateways across different regions.
select
name,
nat_gateway_id,
vpc_id nat_type,
status,
description,
billing_method,
region,
account_id
from
alicloud_vpc_nat_gateway;
select
name,
nat_gateway_id,
vpc_id nat_type,
status,
description,
billing_method,
region,
account_id
from
alicloud_vpc_nat_gateway;
Determine the details of IP addresses associated with Network Address Translation (NAT) gateways to manage and monitor your network's internet connectivity and security.
select
nat_gateway_id,
address ->> 'IpAddress' as ip_address,
address ->> 'AllocationId' as allocation_id
from
alicloud_vpc_nat_gateway,
jsonb_array_elements(ip_lists) as address;
select
nat_gateway_id,
json_extract(address.value, '$.IpAddress') as ip_address,
json_extract(address.value, '$.AllocationId') as allocation_id
from
alicloud_vpc_nat_gateway,
json_each(ip_lists) as address;
Discover the segments that provide private network details for NAT gateways. This query can be used to assess the elements within your network infrastructure and optimize resource allocation based on bandwidth usage and zone distribution.
select
name,
nat_gateway_id,
nat_gateway_private_info ->> 'EniInstanceId' as eni_instance_id,
nat_gateway_private_info ->> 'IzNo' as nat_gateway_zone_id,
nat_gateway_private_info ->> 'MaxBandwidth' as max_bandwidth,
nat_gateway_private_info ->> 'PrivateIpAddress' as private_ip_address,
nat_gateway_private_info ->> 'VswitchId' as vswitch_id
from
alicloud_vpc_nat_gateway;
select
name,
nat_gateway_id,
json_extract(nat_gateway_private_info, '$.EniInstanceId') as eni_instance_id,
json_extract(nat_gateway_private_info, '$.IzNo') as nat_gateway_zone_id,
json_extract(nat_gateway_private_info, '$.MaxBandwidth') as max_bandwidth,
json_extract(nat_gateway_private_info, '$.PrivateIpAddress') as private_ip_address,
json_extract(nat_gateway_private_info, '$.VswitchId') as vswitch_id
from
alicloud_vpc_nat_gateway;
Identify instances where NAT gateways do not have traffic monitoring enabled. This can be useful in ensuring all gateways are properly configured for optimal security and performance.
select
name,
nat_gateway_id,
ecs_metric_enabled
from
alicloud_vpc_nat_gateway
where
not ecs_metric_enabled;
select
name,
nat_gateway_id,
ecs_metric_enabled
from
alicloud_vpc_nat_gateway
where
not ecs_metric_enabled;
Determine the areas in which NAT gateways lack deletion protection to enhance your network's security and prevent accidental data loss.
select
name,
nat_gateway_id,
deletion_protection
from
alicloud_vpc_nat_gateway
where
not deletion_protection;
select
name,
nat_gateway_id,
deletion_protection
from
alicloud_vpc_nat_gateway
where
deletion_protection = 0;
Assess the elements within your Alicloud Virtual Private Cloud (VPC) to understand the distribution of Network Address Translation (NAT) gateways. This allows for effective resource allocation and network planning.
select
vpc_id,
count(*) as nat_gateway_count
from
alicloud_vpc_nat_gateway
group by
vpc_id;
select
vpc_id,
count(*) as nat_gateway_count
from
alicloud_vpc_nat_gateway
group by
vpc_id;