Skip to content
AWS for Query.Farm

aws.lexv2_models.list_bot_recommendations

Example SQL Queries

SELECT * FROM
aws.lexv2_models.list_bot_recommendations
WHERE
"bot_id" = 'VALUE'
AND "bot_version" = 'VALUE'
AND "locale_id" = 'VALUE';

Description

Get a list of bot recommendations that meet the specified criteria.

Table Definition

Column NameColumn Data Type
bot_id Required Input Column

The unique identifier of the bot that contains the bot recommendation list.

VARCHAR
bot_version Required Input Column

The version of the bot that contains the bot recommendation list.

VARCHAR
locale_id Required Input Column

The identifier of the language and locale of the bot recommendation list.

VARCHAR
max_results Input Column

The maximum number of bot recommendations to return in each page of results. 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 ListBotRecommendations operation. If the nextToken field is present, you send the contents as the nextToken parameter of a ListBotRecommendations operation request to get the next page of results. 

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.

bot_recommendation_summaries

Summary information for the bot recommendations that meet the filter specified in this request. The length of the list is specified in the maxResults parameter of the request. If there are more bot recommendations available, the nextToken field contains a token to get the next page of results.

STRUCT(
    "bot_recommendation_status" VARCHAR,
    "bot_recommendation_id" VARCHAR,
    "creation_date_time" TIMESTAMP_S,
    "last_updated_date_time" TIMESTAMP_S
)[]
Show child fields
bot_recommendation_summaries[]
Show child fields
bot_recommendation_summaries[].bot_recommendation_id

The unique identifier of the bot recommendation to be updated.

bot_recommendation_summaries[].bot_recommendation_status

The status of the bot recommendation.

If the status is Failed, then the reasons for the failure are listed in the failureReasons field.

bot_recommendation_summaries[].creation_date_time

A timestamp of the date and time that the bot recommendation was created.

bot_recommendation_summaries[].last_updated_date_time

A timestamp of the date and time that the bot recommendation was last updated.