Skip to content
AWS for Query.Farm

aws.lex_models.get_migration

Example SQL Queries

SELECT * FROM
aws.lex_models.get_migration
WHERE
"migration_id" = 'VALUE';

Description

Provides details about an ongoing or complete migration from an Amazon Lex V1 bot to an Amazon Lex V2 bot. Use this operation to view the migration alerts and warnings related to the migration.

Table Definition

Column NameColumn Data Type
migration_id Required Input Column

The unique identifier of the migration. This is the same as the identifier used when calling the GetMigration operation.

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.

alerts

A list of alerts and warnings that indicate issues with the migration for the Amazon Lex V1 bot to Amazon Lex V2. You receive a warning when an Amazon Lex V1 feature has a different implementation if Amazon Lex V2.

For more information, see Migrating a bot in the Amazon Lex V2 developer guide.

STRUCT(
    "type" VARCHAR,
    "message" VARCHAR,
    "details" VARCHAR[],
    "reference_ur_ls" VARCHAR[]
)[]
Show child fields
alerts[]
Show child fields
alerts[].details[]
alerts[].message

A message that describes why the alert was issued.

alerts[].reference_ur_ls[]
alerts[].type

The type of alert. There are two kinds of alerts:

  • ERROR - There was an issue with the migration that can't be resolved. The migration stops.

  • WARN - There was an issue with the migration that requires manual changes to the new Amazon Lex V2 bot. The migration continues.

migration_status

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

VARCHAR
migration_strategy

The strategy used to conduct the migration.

  • CREATE_NEW - Creates a new Amazon Lex V2 bot and migrates the Amazon Lex V1 bot to the new bot.

  • UPDATE_EXISTING - Overwrites the existing Amazon Lex V2 bot metadata and the locale being migrated. It doesn't change any other locales in the Amazon Lex V2 bot. If the locale doesn't exist, a new locale is created in the Amazon Lex V2 bot.

VARCHAR
migration_timestamp

The date and time that the migration started.

TIMESTAMP_S
v1_bot_locale

The locale of the Amazon Lex V1 bot migrated to Amazon Lex V2.

VARCHAR
v1_bot_name

The name of the Amazon Lex V1 bot migrated to Amazon Lex V2.

VARCHAR
v1_bot_version

The version of the Amazon Lex V1 bot migrated to Amazon Lex V2.

VARCHAR
v2_bot_id

The unique identifier of the Amazon Lex V2 bot that the Amazon Lex V1 is being migrated to.

VARCHAR
v2_bot_role

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

VARCHAR