Skip to main content
Version: 0.0.25

Table: vpc

Table to manage AWS VPC entries. Amazon Virtual Private Cloud (Amazon VPC) gives you full control over your virtual networking environment, including resource placement, connectivity, and security.


SELECT * FROM iasql_install('aws_vpc');

INSERT INTO vpc (cidr_block) VALUES ('');

SELECT * FROM vpc WHERE cidr_block='' AND state='available';

INSERT INTO subnet (availability_zone, vpc_id, cidr_block) SELECT
(SELECT * FROM availability_zone LIMIT 1), id, '' FROM vpc
WHERE is_default = false AND cidr_block = '';

DELETE FROM vpc WHERE cidr_block = '';



cidr_block: string

Amazon VPC supports IPv4 and IPv6 addressing. A VPC must have an IPv4 CIDR block associated with it.


enable_dns_hostnames: boolean

Determines whether the VPC supports assigning public DNS hostnames to instances with public IP addresses. The default for this attribute is false unless the VPC is a default VPC.


enable_dns_support: boolean

Determines whether the VPC supports DNS resolution through the Amazon provided DNS server. If this attribute is true, queries to the Amazon provided DNS server succeed. For more information, see Amazon DNS server. The default for this attribute is true.


enable_network_address_usage_metrics: boolean

Defines if Network Address Usage (NAU) is enabled. NAU is a metric applied to resources in your virtual network to help you plan for and monitor the size of your VPC. Each NAU unit contributes to a total that represents the size of your VPC.


is_default: boolean

Whether this VPC is the default one When you start using Amazon VPC, you have a default VPC in each AWS Region. A default VPC comes with a public subnet in each Availability Zone, an internet gateway, and settings to enable DNS resolution.


region: string

Reference to the region where it belongs

Optional state: vpc_state

Current state for the VPC

Optional tags: Object

Complex type to provide identifier tags for the VPC

Type definition

[key: string]: string

Optional vpc_id: string

AWS ID used to identify the VPC