Skip to main content
Version: 0.0.25

Table: nat_gateway

Table to manage AWS NAT Gateway instances. A NAT gateway is a Network Address Translation (NAT) service. You can use a NAT gateway so that instances in a private subnet can connect to services outside your VPC but external services cannot initiate a connection with those instances.

Example

INSERT INTO nat_gateway (connectivity_type, subnet_id, tags) SELECT 'private', id, '{"Name":"nat_gateway"}
FROM subnet WHERE cidr_block = '191.0.0.0/16';

SELECT * FROM nat_gateway WHERE tags ->> 'name' = 'nat_gateway';

DELETE FROM nat_gateway WHERE tags ->> 'name' = 'nat_gateway';

See

Columns

connectivity_type: connectivity_type

Connectivity type for this NAT gateway

Optional elastic_ip: elastic_ip

Reference to the elastic IP used by this NAT gateway

See

https://docs.aws.amazon.com/vpc/latest/userguide/vpc-nat-gateway.html

Optional nat_gateway_id: string

AWS ID to identify the NAT gateway

region: string

Reference to the region where it belongs

Optional state: nat_gateway_state

Current state for the gateway

Optional subnet: subnet

Reference to the associated subnets for the NAT gateway

See

https://aws.amazon.com/premiumsupport/knowledge-center/nat-gateway-vpc-private-subnet/

Optional tags: Object

Complex type to provide identifier tags for the gateway

Type definition

[key: string]: string