Skip to content

aws.lexv2_models.describe_bot

Example SQL Queries

SELECT * FROM
aws.lexv2_models.describe_bot
WHERE
"bot_id" = 'VALUE';

Description

Provides metadata information about a bot.

Table Definition

Column NameColumn Data Type
bot_id Required Input Column

The unique identifier of the bot.

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_members

The list of bots in the network that was described.

STRUCT(
"bot_member_id" VARCHAR,
"bot_member_name" VARCHAR,
"bot_member_alias_id" VARCHAR,
"bot_member_alias_name" VARCHAR,
"bot_member_version" VARCHAR
)[]
Show child fields
bot_members[]
Show child fields
bot_members[].bot_member_alias_id

The alias ID of a bot that is a member of this network of bots.

bot_members[].bot_member_alias_name

The alias name of a bot that is a member of this network of bots.

bot_members[].bot_member_id

The unique ID of a bot that is a member of this network of bots.

bot_members[].bot_member_name

The unique name of a bot that is a member of this network of bots.

bot_members[].bot_member_version

The version of a bot that is a member of this network of bots.

bot_name

The name of the bot.

VARCHAR
bot_status

The current status of the bot. When the status is Available the bot is ready to be used in conversations with users.

VARCHAR
bot_type

The type of the bot that was described.

VARCHAR
creation_date_time

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

TIMESTAMP_S
data_privacy

Settings for managing data privacy of the bot and its conversations with users.

STRUCT(
"child_directed" BOOLEAN
)
Show child fields
data_privacy.child_directed

For each Amazon Lex bot created with the Amazon Lex Model Building Service, you must specify whether your use of Amazon Lex is related to a website, program, or other application that is directed or targeted, in whole or in part, to children under age 13 and subject to the Children's Online Privacy Protection Act (COPPA) by specifying true or false in the childDirected field. By specifying true in the childDirected field, you confirm that your use of Amazon Lex is related to a website, program, or other application that is directed or targeted, in whole or in part, to children under age 13 and subject to COPPA. By specifying false in the childDirected field, you confirm that your use of Amazon Lex is not related to a website, program, or other application that is directed or targeted, in whole or in part, to children under age 13 and subject to COPPA. You may not specify a default value for the childDirected field that does not accurately reflect whether your use of Amazon Lex is related to a website, program, or other application that is directed or targeted, in whole or in part, to children under age 13 and subject to COPPA. If your use of Amazon Lex relates to a website, program, or other application that is directed in whole or in part, to children under age 13, you must obtain any required verifiable parental consent under COPPA. For information regarding the use of Amazon Lex in connection with websites, programs, or other applications that are directed or targeted, in whole or in part, to children under age 13, see the Amazon Lex FAQ.

description

The description of the bot.

VARCHAR
failure_reasons

If the botStatus is Failed, this contains a list of reasons that the bot couldn't be built.

VARCHAR[]
Show child fields
failure_reasons[]
idle_session_ttl_in_seconds

The maximum time in seconds that Amazon Lex retains the data gathered in a conversation.

BIGINT
last_updated_date_time

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

TIMESTAMP_S
role_arn

The Amazon Resource Name (ARN) of an IAM role that has permission to access the bot.

VARCHAR