Skip to content
AWS for Query.Farm

aws.lookoutequipment.list_model_versions

Example SQL Queries

SELECT * FROM
aws.lookoutequipment.list_model_versions
WHERE
"model_name" = 'VALUE';

Description

Generates a list of all model versions for a given model, including the model version, model version ARN, and status. To list a subset of versions, use the MaxModelVersion and MinModelVersion fields.

Table Definition

Column NameColumn Data Type
model_name Required Input Column

Then name of the machine learning model for which the model versions are to be listed.

VARCHAR
created_at_end_time Input Column

Filter results to return all the model versions created before this time.

TIMESTAMP_S
created_at_start_time Input Column

Filter results to return all the model versions created after this time.

TIMESTAMP_S
max_model_version Input Column

Specifies the highest version of the model to return in the list.

BIGINT
max_results Input Column

Specifies the maximum number of machine learning model versions to list.

BIGINT
min_model_version Input Column

Specifies the lowest version of the model to return in the list.

BIGINT
next_token Input Column

If the total number of results exceeds the limit that the response can display, the response returns an opaque pagination token indicating where to continue the listing of machine learning model versions. Use this token in the NextToken field in the request to list the next page of results.

VARCHAR
source_type Input Column

Filter the results based on the way the model version was generated.

VARCHAR
status Input Column

Filter the results based on the current status of the model version.

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.

_aws_region Input Column

The AWS region to use.

VARCHAR
model_version_summaries

Provides information on the specified model version, including the created time, model and dataset ARNs, and status.

If you don't supply the ModelName request parameter, or if you supply the name of a model that doesn't exist, ListModelVersions returns an empty array in ModelVersionSummaries. 

STRUCT(
    "model_name" VARCHAR,
    "model_arn" VARCHAR,
    "model_version" BIGINT,
    "model_version_arn" VARCHAR,
    "created_at" TIMESTAMP_S,
    "status" VARCHAR,
    "source_type" VARCHAR,
    "model_quality" VARCHAR
)[]
Show child fields
model_version_summaries[]
Show child fields
model_version_summaries[].created_at

The time when this model version was created.

model_version_summaries[].model_arn

The Amazon Resource Name (ARN) of the model that this model version is a version of.

model_version_summaries[].model_name

The name of the model that this model version is a version of.

model_version_summaries[].model_quality

Provides a quality assessment for a model that uses labels. If Lookout for Equipment determines that the model quality is poor based on training metrics, the value is POOR_QUALITY_DETECTED. Otherwise, the value is QUALITY_THRESHOLD_MET.

If the model is unlabeled, the model quality can't be assessed and the value of ModelQuality is CANNOT_DETERMINE_QUALITY. In this situation, you can get a model quality assessment by adding labels to the input dataset and retraining the model.

For information about improving the quality of a model, see Best practices with Amazon Lookout for Equipment.

model_version_summaries[].model_version

The version of the model.

model_version_summaries[].model_version_arn

The Amazon Resource Name (ARN) of the model version.

model_version_summaries[].source_type

Indicates how this model version was generated.

model_version_summaries[].status

The current status of the model version.