Table: alicloud_vpc_nat_gateway

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.

Examples

Basic info

select
  name,
  nat_gateway_id,
  vpc_id nat_type,
  status,
  description,
  billing_method,
  region,
  account_id
from
  alicloud_vpc_nat_gateway;

List IP address details for NAT gateways

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;

List private network info for NAT gateways

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;

List NAT gateways that have traffic monitoring disabled

select
  name,
  nat_gateway_id,
  ecs_metric_enabled
from
  alicloud_vpc_nat_gateway
where
  not ecs_metric_enabled;

List NAT gateways that have deletion protection disabled

select
  name,
  nat_gateway_id,
  deletion_protection
from
  alicloud_vpc_nat_gateway
where
  not deletion_protection;

Count of NAT gateways per VPC ID

select
  vpc_id,
  count(*) as nat_gateway_count
from
  alicloud_vpc_nat_gateway
group by
  vpc_id;

Query examples

Control examples

.inspect alicloud_vpc_nat_gateway

Aliclod VPC NAT Gateway

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The Alicloud Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
auto_pay	boolean	Indicates whether auto pay is enabled.
billing_method	text	The billing method of the NAT gateway.
business_status	text	The status of the NAT gateway.
creation_time	timestamp with time zone	The time when the NAT gateway was created.
deletion_protection	boolean	Indicates whether deletion protection is enabled.
description	text	The description of the NAT gateway.
ecs_metric_enabled	boolean	Indicates whether the traffic monitoring feature is enabled.
expired_ime	timestamp with time zone	The time when the NAT gateway expires.
forward_table_ids	jsonb	The ID of the Destination Network Address Translation (DNAT) table.
internet_charge_type	text	The billing method of the NAT gateway.
ip_lists	jsonb	The elastic IP address (EIP) that is associated with the NAT gateway.
name	text	The name of the NAT gateway.
nat_gateway_id	text	The ID of the NAT gateway.
nat_gateway_private_info	jsonb	The information of the virtual private cloud (VPC) to which the enhanced NAT gateway belongs.
nat_type	text	The type of the NAT gateway. Valid values: 'Normal' and 'Enhanced'.
region	text	The Alicloud region in which the resource is located.
resource_group_id	text	The ID of the resource group.
snat_table_ids	jsonb	The ID of the SNAT table for the NAT gateway.
spec	text	The size of the NAT gateway.
status	text	The state of the NAT gateway.
title	text	Title of the resource.
vpc_id	text	The ID of the virtual private cloud (VPC) to which the NAT gateway belongs.

turbot/alicloud