Skip to content
AWS for Query.Farm

aws.elasticache.describe_cache_subnet_groups

Example SQL Queries

SELECT * FROM
aws.elasticache.describe_cache_subnet_groups;

Description

Returns a list of cache subnet group descriptions. If a subnet group name is specified, the list contains only the description of that group. This is applicable only when you have ElastiCache in VPC setup. All ElastiCache clusters now launch in VPC by default.

Table Definition

Column NameColumn Data Type
cache_subnet_group_name Input Column

The name of the cache subnet group.

VARCHAR
_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
arn

The ARN (Amazon Resource Name) of the cache subnet group.

VARCHAR
cache_subnet_group_description

The description of the cache subnet group.

VARCHAR
subnets

A list of subnets associated with the cache subnet group.

STRUCT(
    "subnet_identifier" VARCHAR,
    "subnet_availability_zone" STRUCT(
        "name" VARCHAR
    ),
    "subnet_outpost" STRUCT(
        "subnet_outpost_arn" VARCHAR
    ),
    "supported_network_types" VARCHAR[]
)[]
Show child fields
subnets[]
Show child fields
subnets[].subnet_availability_zone

The Availability Zone associated with the subnet.

Show child fields
subnets[].subnet_availability_zone.name

The name of the Availability Zone.

subnets[].subnet_identifier

The unique identifier for the subnet.

subnets[].subnet_outpost

The outpost ARN of the subnet.

Show child fields
subnets[].subnet_outpost.subnet_outpost_arn

The outpost ARN of the subnet.

subnets[].supported_network_types[]
supported_network_types

Either ipv4 | ipv6 | dual_stack. IPv6 is supported for workloads using Redis OSS engine version 6.2 onward or Memcached engine version 1.6.6 on all instances built on the Nitro system.

VARCHAR[]
Show child fields
supported_network_types[]
vpc_id

The Amazon Virtual Private Cloud identifier (VPC ID) of the cache subnet group.

VARCHAR