Skip to content

aws.ec2.describe_network_acls

Example SQL Queries

SELECT * FROM
aws.ec2.describe_network_acls;

Description

Describes your network ACLs. The default is to describe all your network ACLs. Alternatively, you can specify specific network ACL IDs or filter the results to include only the network ACLs that match specific criteria.

For more information, see Network ACLs in the Amazon VPC User Guide.

Table Definition

Column NameColumn Data Type
dry_run Input Column

Checks whether you have the required permissions for the action, without actually making the request, and provides an error response. If you have the required permissions, the error response is DryRunOperation. Otherwise, it is UnauthorizedOperation.

BOOLEAN
filters Input Column

The filters.

  • association.association-id - The ID of an association ID for the ACL.

  • association.network-acl-id - The ID of the network ACL involved in the association.

  • association.subnet-id - The ID of the subnet involved in the association.

  • default - Indicates whether the ACL is the default network ACL for the VPC.

  • entry.cidr - The IPv4 CIDR range specified in the entry.

  • entry.icmp.code - The ICMP code specified in the entry, if any.

  • entry.icmp.type - The ICMP type specified in the entry, if any.

  • entry.ipv6-cidr - The IPv6 CIDR range specified in the entry.

  • entry.port-range.from - The start of the port range specified in the entry.

  • entry.port-range.to - The end of the port range specified in the entry.

  • entry.protocol - The protocol specified in the entry (tcp | udp | icmp or a protocol number).

  • entry.rule-action - Allows or denies the matching traffic (allow | deny).

  • entry.egress - A Boolean that indicates the type of rule. Specify true for egress rules, or false for ingress rules.

  • entry.rule-number - The number of an entry (in other words, rule) in the set of ACL entries.

  • network-acl-id - The ID of the network ACL.

  • owner-id - The ID of the Amazon Web Services account that owns the network ACL.

  • tag:<key> - The key/value combination of a tag assigned to the resource. Use the tag key in the filter name and the tag value as the filter value. For example, to find all resources that have a tag with the key Owner and the value TeamA, specify tag:Owner for the filter name and TeamA for the filter value.

  • tag-key - The key of a tag assigned to the resource. Use this filter to find all resources assigned a tag with a specific key, regardless of the tag value.

  • vpc-id - The ID of the VPC for the network ACL.

STRUCT(
"name" VARCHAR,
"values" VARCHAR[]
)[]
Show child fields
filters[]
Show child fields
filters[].name

The name of the filter. Filter names are case-sensitive.

filters[].values[]
network_acl_ids Input Column

The IDs of the network ACLs.

VARCHAR[]
Show child fields
network_acl_ids[]
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

_aws_region Input Column

The AWS region to use.

VARCHAR
associations

Any associations between the network ACL and your subnets

STRUCT(
"network_acl_association_id" VARCHAR,
"network_acl_id" VARCHAR,
"subnet_id" VARCHAR
)[]
Show child fields
associations[]
Show child fields
associations[].network_acl_association_id

The ID of the association between a network ACL and a subnet.

associations[].network_acl_id

The ID of the network ACL.

associations[].subnet_id

The ID of the subnet.

entries

The entries (rules) in the network ACL.

STRUCT(
"cidr_block" VARCHAR,
"egress" BOOLEAN,
"icmp_type_code" STRUCT(
"code" BIGINT,
"type" BIGINT
),
"ipv6_cidr_block" VARCHAR,
"port_range" STRUCT(
"from" BIGINT,
"to" BIGINT
),
"protocol" VARCHAR,
"rule_action" VARCHAR,
"rule_number" BIGINT
)[]
Show child fields
entries[]
Show child fields
entries[].cidr_block

The IPv4 network range to allow or deny, in CIDR notation.

entries[].egress

Indicates whether the rule is an egress rule (applied to traffic leaving the subnet).

entries[].icmp_type_code

ICMP protocol: The ICMP type and code.

Show child fields
entries[].icmp_type_code.code

The ICMP code. A value of -1 means all codes for the specified ICMP type.

entries[].icmp_type_code.type

The ICMP type. A value of -1 means all types.

entries[].ipv6_cidr_block

The IPv6 network range to allow or deny, in CIDR notation.

entries[].port_range

TCP or UDP protocols: The range of ports the rule applies to.

Show child fields
entries[].port_range.from

The first port in the range.

entries[].port_range.to

The last port in the range.

entries[].protocol

The protocol number. A value of "-1" means all protocols.

entries[].rule_action

Indicates whether to allow or deny the traffic that matches the rule.

entries[].rule_number

The rule number for the entry. ACL entries are processed in ascending order by rule number.

is_default

Indicates whether this is the default network ACL for the VPC.

BOOLEAN
network_acl_id

The ID of the network ACL.

VARCHAR
owner_id

The ID of the Amazon Web Services account that owns the network ACL.

VARCHAR
tags

Any tags assigned to the network ACL.

STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
Show child fields
tags[]
Show child fields
tags[].key

The key of the tag.

Constraints: Tag keys are case-sensitive and accept a maximum of 127 Unicode characters. May not begin with aws:.

tags[].value

The value of the tag.

Constraints: Tag values are case-sensitive and accept a maximum of 256 Unicode characters.

vpc_id

The ID of the VPC for the network ACL.

VARCHAR