Skip to content

aws.pinpoint_sms_voice_v2.describe_configuration_sets

Example SQL Queries

SELECT * FROM
aws.pinpoint_sms_voice_v2.describe_configuration_sets;

Description

Describes the specified configuration sets or all in your account.

If you specify configuration set names, the output includes information for only the specified configuration sets. If you specify filters, the output includes information for only those configuration sets that meet the filter criteria. If you don't specify configuration set names or filters, the output includes information for all configuration sets.

If you specify a configuration set name that isn't valid, an error is returned.

Table Definition

Column NameColumn Data Type
configuration_set_names Input Column

An array of strings. Each element can be either a ConfigurationSetName or ConfigurationSetArn.

VARCHAR[]
Show child fields
configuration_set_names[]
filters Input Column

An array of filters to apply to the results that are returned.

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

The name of the attribute to filter on.

filters[].values[]
_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.

configuration_set_arn

The Resource Name (ARN) of the ConfigurationSet.

VARCHAR
configuration_set_name

The name of the ConfigurationSet.

VARCHAR
created_timestamp

The time when the ConfigurationSet was created, in UNIX epoch time format.

TIMESTAMP_S
default_message_type

The type of message. Valid values are TRANSACTIONAL for messages that are critical or time-sensitive and PROMOTIONAL for messages that aren't critical or time-sensitive.

VARCHAR
default_sender_id

The default sender ID used by the ConfigurationSet.

VARCHAR
event_destinations

An array of EventDestination objects that describe any events to log and where to log them.

STRUCT(
"event_destination_name" VARCHAR,
"enabled" BOOLEAN,
"matching_event_types" VARCHAR[],
"cloud_watch_logs_destination" STRUCT(
"iam_role_arn" VARCHAR,
"log_group_arn" VARCHAR
),
"kinesis_firehose_destination" STRUCT(
"iam_role_arn" VARCHAR,
"delivery_stream_arn" VARCHAR
),
"sns_destination" STRUCT(
"topic_arn" VARCHAR
)
)[]
Show child fields
event_destinations[]
Show child fields
event_destinations[].cloud_watch_logs_destination

An object that contains information about an event destination that sends logging events to Amazon CloudWatch logs.

Show child fields
event_destinations[].cloud_watch_logs_destination.iam_role_arn

The Amazon Resource Name (ARN) of an Identity and Access Management role that is able to write event data to an Amazon CloudWatch destination.

event_destinations[].cloud_watch_logs_destination.log_group_arn

The name of the Amazon CloudWatch log group that you want to record events in.

event_destinations[].enabled

When set to true events will be logged.

event_destinations[].event_destination_name

The name of the EventDestination.

event_destinations[].kinesis_firehose_destination

An object that contains information about an event destination for logging to Amazon Data Firehose.

Show child fields
event_destinations[].kinesis_firehose_destination.delivery_stream_arn

The Amazon Resource Name (ARN) of the delivery stream.

event_destinations[].kinesis_firehose_destination.iam_role_arn

The ARN of an Identity and Access Management role that is able to write event data to an Amazon Data Firehose destination.

event_destinations[].matching_event_types[]
event_destinations[].sns_destination

An object that contains information about an event destination that sends logging events to Amazon SNS.

Show child fields
event_destinations[].sns_destination.topic_arn

The Amazon Resource Name (ARN) of the Amazon SNS topic that you want to publish events to.

protect_configuration_id

The unique identifier for the protect configuration.

VARCHAR