steampipe plugin install aws

Table: aws_dax_subnet_group - Query AWS DAX Subnet Group using SQL

The AWS DAX Subnet Group is a resource in Amazon DynamoDB Accelerator (DAX) that allows you to specify a particular subnet group when you create a DAX cluster. A subnet group is a collection of subnets (typically private) that you can designate for your clusters running in a virtual private cloud (VPC). This allows you to configure network access to your DAX clusters.

Table Usage Guide

The aws_dax_subnet_group table in Steampipe provides you with information about subnet groups within Amazon DynamoDB Accelerator (DAX). This table allows you, as a DevOps engineer, to query subnet group-specific details, including the subnet group name, description, VPC ID, and the subnets in the group. You can utilize this table to gather insights on subnet groups, such as their associated VPCs, subnet IDs, and more. The schema outlines the various attributes of the DAX subnet group for you, including the subnet group name, VPC ID, subnet ID, and associated tags.

Examples

Basic info

Explore which AWS DAX subnet groups are in use, gaining insights into their associated VPCs and regions. This can be useful for assessing your network's configuration and understanding its geographical distribution.

select
subnet_group_name,
description,
vpc_id,
subnets,
region
from
aws_dax_subnet_group;
select
subnet_group_name,
description,
vpc_id,
subnets,
region
from
aws_dax_subnet_group;

List VPC details for each subnet group

Determine the areas in which each subnet group is associated with specific VPC details. This can be useful in understanding the configuration and state of your network for better resource management and security.

select
subnet_group_name,
v.vpc_id,
v.arn as vpc_arn,
v.cidr_block as vpc_cidr_block,
v.state as vpc_state,
v.is_default as is_default_vpc,
v.region
from
aws_dax_subnet_group g
join aws_vpc v on v.vpc_id = g.vpc_id;
select
subnet_group_name,
v.vpc_id,
v.arn as vpc_arn,
v.cidr_block as vpc_cidr_block,
v.state as vpc_state,
v.is_default as is_default_vpc,
v.region
from
aws_dax_subnet_group g
join aws_vpc v on v.vpc_id = g.vpc_id;

List subnet details for each subnet group

This query is useful for gaining insights into the specific details of each subnet group within a network. Using this information, one could optimize network structure, improve resource allocation, or enhance security measures.

select
subnet_group_name,
g.vpc_id,
vs.subnet_arn,
vs.cidr_block as subnet_cidr_block,
vs.state as subnet_state,
vs.availability_zone as subnet_availability_zone,
vs.region
from
aws_dax_subnet_group g,
jsonb_array_elements(subnets) s
join aws_vpc_subnet vs on vs.subnet_id = s ->> 'SubnetIdentifier';
select
subnet_group_name,
g.vpc_id,
vs.subnet_arn,
vs.cidr_block as subnet_cidr_block,
vs.state as subnet_state,
vs.availability_zone as subnet_availability_zone,
vs.region
from
aws_dax_subnet_group g,
json_each(subnets) s
join aws_vpc_subnet vs on vs.subnet_id = json_extract(s.value, '$.SubnetIdentifier');

Schema for aws_dax_subnet_group

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
descriptiontextThe description of the subnet group.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
subnet_group_nametext=The name of the subnet group.
subnetsjsonbA list of subnets associated with the subnet group.
titletextTitle of the resource.
vpc_idtextThe Amazon Virtual Private Cloud identifier (VPC ID) of the subnet group.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_dax_subnet_group