Skip to content
AWS for Query.Farm

aws.lexv2_models.list_bot_locales

Example SQL Queries

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

Description

Gets a list of locales for the specified bot.

Table Definition

Column NameColumn Data Type
bot_id Required Input Column

The identifier of the bot to list locales for.

VARCHAR
bot_version Required Input Column

The version of the bot.

VARCHAR
filters Input Column

Provides the specification for a filter used to limit the response to only those locales that match the filter specification. You can only specify one filter and one value to filter on.

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

The name of the field to filter the list of bots.

filters[].operator

The operator to use for the filter. Specify EQ when the ListBotLocales operation should return only aliases that equal the specified value. Specify CO when the ListBotLocales operation should return aliases that contain the specified value.

filters[].values[]
max_results Input Column

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

VARCHAR
sort_by Input Column

Specifies sorting parameters for the list of locales. You can sort by locale name in ascending or descending order.

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

The bot locale attribute to sort by.

sort_by.order

Specifies whether to sort the bot locales 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.

bot_locale_summaries

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

STRUCT(
    "locale_id" VARCHAR,
    "locale_name" VARCHAR,
    "description" VARCHAR,
    "bot_locale_status" VARCHAR,
    "last_updated_date_time" TIMESTAMP_S,
    "last_build_submitted_date_time" TIMESTAMP_S
)[]
Show child fields
bot_locale_summaries[]
Show child fields
bot_locale_summaries[].bot_locale_status

The current status of the bot locale. When the status is Built the locale is ready for use.

bot_locale_summaries[].description

The description of the bot locale.

bot_locale_summaries[].last_build_submitted_date_time

A timestamp of the date and time that the bot locale was last built.

bot_locale_summaries[].last_updated_date_time

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

bot_locale_summaries[].locale_id

The language and locale of the bot locale.

bot_locale_summaries[].locale_name

The name of the bot locale.