Skip to content
AWS for Query.Farm

aws.lex_models.get_migrations

Example SQL Queries

SELECT * FROM
aws.lex_models.get_migrations;

Description

Gets a list of migrations between Amazon Lex V1 and Amazon Lex V2.

Table Definition

Column NameColumn Data Type
max_results Input Column

The maximum number of migrations to return in the response. The default is 10.

BIGINT
migration_status_equals Input Column

Filters the list to contain only migrations in the specified state.

VARCHAR
next_token Input Column

If the response is truncated, it includes a pagination token that you can specify in your next request to fetch the next page of migrations.

VARCHAR
sort_by_attribute Input Column

The field to sort the list of migrations by. You can sort by the Amazon Lex V1 bot name or the date and time that the migration was started.

VARCHAR
sort_by_order Input Column

The order so sort the list.

VARCHAR
v1_bot_name_contains Input Column

Filters the list to contain only bots whose name contains the specified string. The string is matched anywhere in bot name.

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.

migration_summaries

An array of summaries for migrations from Amazon Lex V1 to Amazon Lex V2. To see details of the migration, use the migrationId from the summary in a call to the operation.

STRUCT(
    "migration_id" VARCHAR,
    "v1_bot_name" VARCHAR,
    "v1_bot_version" VARCHAR,
    "v1_bot_locale" VARCHAR,
    "v2_bot_id" VARCHAR,
    "v2_bot_role" VARCHAR,
    "migration_status" VARCHAR,
    "migration_strategy" VARCHAR,
    "migration_timestamp" TIMESTAMP_S
)[]
Show child fields
migration_summaries[]
Show child fields
migration_summaries[].migration_id

The unique identifier that Amazon Lex assigned to the migration.

migration_summaries[].migration_status

The status of the operation. When the status is COMPLETE the bot is available in Amazon Lex V2. There may be alerts and warnings that need to be resolved to complete the migration.

migration_summaries[].migration_strategy

The strategy used to conduct the migration.

migration_summaries[].migration_timestamp

The date and time that the migration started.

migration_summaries[].v1_bot_locale

The locale of the Amazon Lex V1 bot that is the source of the migration.

migration_summaries[].v1_bot_name

The name of the Amazon Lex V1 bot that is the source of the migration.

migration_summaries[].v1_bot_version

The version of the Amazon Lex V1 bot that is the source of the migration.

migration_summaries[].v2_bot_id

The unique identifier of the Amazon Lex V2 that is the destination of the migration.

migration_summaries[].v2_bot_role

The IAM role that Amazon Lex uses to run the Amazon Lex V2 bot.