Skip to content

aws.lexv2_models.list_test_executions

Example SQL Queries

SELECT * FROM
aws.lexv2_models.list_test_executions;

Description

The list of test set executions.

Table Definition

Column NameColumn Data Type
max_results Input Column

The maximum number of test executions 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 ListTestExecutions operation. If the nextToken field is present, you send the contents as the nextToken parameter of a ListTestExecutions operation request to get the next page of results.

VARCHAR
sort_by Input Column

The sort order of the test set executions.

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

Specifies whether to sort the test set executions by the date and time at which the test sets were created.

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_executions

The list of test executions.

STRUCT(
"test_execution_id" VARCHAR,
"creation_date_time" TIMESTAMP_S,
"last_updated_date_time" TIMESTAMP_S,
"test_execution_status" VARCHAR,
"test_set_id" VARCHAR,
"test_set_name" VARCHAR,
"target" STRUCT(
"bot_alias_target" STRUCT(
"bot_id" VARCHAR,
"bot_alias_id" VARCHAR,
"locale_id" VARCHAR
)
),
"api_mode" VARCHAR,
"test_execution_modality" VARCHAR
)[]
Show child fields
test_executions[]
Show child fields
test_executions[].api_mode

Specifies whether the API mode for the test execution is streaming or non-streaming.

test_executions[].creation_date_time

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

test_executions[].last_updated_date_time

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

test_executions[].target

Contains information about the bot used for the test execution..

Show child fields
test_executions[].target.bot_alias_target

Contains information about the bot alias used for the test execution.

Show child fields
test_executions[].target.bot_alias_target.bot_alias_id

The bot alias Id of the bot alias used in the test set execution.

test_executions[].target.bot_alias_target.bot_id

The bot Id of the bot alias used in the test set execution.

test_executions[].target.bot_alias_target.locale_id

The locale Id of the bot alias used in the test set execution.

test_executions[].test_execution_id

The unique identifier of the test execution.

test_executions[].test_execution_modality

Specifies whether the data used for the test execution is written or spoken.

test_executions[].test_execution_status

The current status of the test execution.

test_executions[].test_set_id

The unique identifier of the test set used in the test execution.

test_executions[].test_set_name

The name of the test set used in the test execution.