Skip to content
AWS for Query.Farm

aws.voice_id.list_domains

Example SQL Queries

SELECT * FROM
aws.voice_id.list_domains;

Description

Lists all the domains in the Amazon Web Services account.

Table Definition

Column NameColumn Data Type
_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.

arn

The Amazon Resource Name (ARN) for the domain.

VARCHAR
created_at

The timestamp of when the domain was created.

TIMESTAMP_S
description

The description of the domain.

VARCHAR
domain_id

The identifier of the domain.

VARCHAR
domain_status

The current status of the domain.

VARCHAR
name

The client-provided name for the domain.

VARCHAR
server_side_encryption_configuration

The server-side encryption configuration containing the KMS key identifier you want Voice ID to use to encrypt your data.

STRUCT(
    "kms_key_id" VARCHAR
)
Show child fields
server_side_encryption_configuration.kms_key_id

The identifier of the KMS key to use to encrypt data stored by Voice ID. Voice ID doesn't support asymmetric customer managed keys.

server_side_encryption_update_details

Details about the most recent server-side encryption configuration update. When the server-side encryption configuration is changed, dependency on the old KMS key is removed through an asynchronous process. When this update is complete, the domain's data can only be accessed using the new KMS key.

STRUCT(
    "message" VARCHAR,
    "old_kms_key_id" VARCHAR,
    "update_status" VARCHAR
)
Show child fields
server_side_encryption_update_details.message

Message explaining the current UpdateStatus. When the UpdateStatus is FAILED, this message explains the cause of the failure.

server_side_encryption_update_details.old_kms_key_id

The previous KMS key ID the domain was encrypted with, before ServerSideEncryptionConfiguration was updated to a new KMS key ID.

server_side_encryption_update_details.update_status

Status of the server-side encryption update. During an update, if there is an issue with the domain's current or old KMS key ID, such as an inaccessible or disabled key, then the status is FAILED. In order to resolve this, the key needs to be made accessible, and then an UpdateDomain call with the existing server-side encryption configuration will re-attempt this update process.

updated_at

The timestamp of when the domain was last updated.

TIMESTAMP_S
watchlist_details

Provides information about watchlistDetails and DefaultWatchlistID. 

STRUCT(
    "default_watchlist_id" VARCHAR
)
Show child fields
watchlist_details.default_watchlist_id

The identifier of the default watchlist.