Skip to content
AWS for Query.Farm

aws.lexv2_models.list_test_sets

Example SQL Queries

SELECT * FROM
aws.lexv2_models.list_test_sets;

Description

The list of the test sets

Table Definition

Column NameColumn Data Type
max_results Input Column

The maximum number of test sets to return in each page. If there are fewer results than the max page size, only the actual number of results are returned.

BIGINT
next_token Input Column

A token that indicates whether there are more results to return in a response to the ListTestSets operation. If the nextToken field is present, you send the contents as the nextToken parameter of a ListTestSets operation request to get the next page of results.

VARCHAR
sort_by Input Column

The sort order for the list of test sets.

STRUCT(
    "attribute" VARCHAR,
    "order" VARCHAR
)
Show child fields
sort_by.attribute

Specifies whether to sort the test sets by name or by the time they were last updated.

sort_by.order

Specifies whether to sort in ascending or descending order.

_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.

test_sets

The selected test sets in a list of test sets.

STRUCT(
    "test_set_id" VARCHAR,
    "test_set_name" VARCHAR,
    "description" VARCHAR,
    "modality" VARCHAR,
    "status" VARCHAR,
    "role_arn" VARCHAR,
    "num_turns" BIGINT,
    "storage_location" STRUCT(
        "s3_bucket_name" VARCHAR,
        "s3_path" VARCHAR,
        "kms_key_arn" VARCHAR
    ),
    "creation_date_time" TIMESTAMP_S,
    "last_updated_date_time" TIMESTAMP_S
)[]
Show child fields
test_sets[]
Show child fields
test_sets[].creation_date_time

The date and time at which the test set was created.

test_sets[].description

The description of the test set.

test_sets[].last_updated_date_time

The date and time at which the test set was last updated.

test_sets[].modality

Specifies whether the test set contains written or spoken data.

test_sets[].num_turns

The number of turns in the test set.

test_sets[].role_arn

The Amazon Resource Name (ARN) of an IAM role that has permission to access the test set.

test_sets[].status

The status of the test set.

test_sets[].storage_location

Contains information about the location at which the test set is stored.

Show child fields
test_sets[].storage_location.kms_key_arn

The Amazon Resource Name (ARN) of an Amazon Web Services Key Management Service (KMS) key for encrypting the test set.

test_sets[].storage_location.s3_bucket_name

The name of the Amazon S3 bucket in which the test set is stored.

test_sets[].storage_location.s3_path

The path inside the Amazon S3 bucket where the test set is stored.

test_sets[].test_set_id

The unique identifier of the test set.

test_sets[].test_set_name

The name of the test set.