Skip to content
AWS for Query.Farm

aws.lookoutequipment.list_inference_executions

Example SQL Queries

SELECT * FROM
aws.lookoutequipment.list_inference_executions
WHERE
"inference_scheduler_name" = 'VALUE';

Description

Lists all inference executions that have been performed by the specified inference scheduler.

Table Definition

Column NameColumn Data Type
inference_scheduler_name Required Input Column

The name of the inference scheduler for the inference execution listed. 

VARCHAR
data_end_time_before Input Column

The time reference in the inferenced dataset before which Amazon Lookout for Equipment stopped the inference execution. 

TIMESTAMP_S
data_start_time_after Input Column

The time reference in the inferenced dataset after which Amazon Lookout for Equipment started the inference execution. 

TIMESTAMP_S
max_results Input Column

Specifies the maximum number of inference executions to list. 

BIGINT
next_token Input Column

An opaque pagination token indicating where to continue the listing of inference executions. 

VARCHAR
status Input Column

The status of the inference execution. 

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
inference_execution_summaries

Provides an array of information about the individual inference executions returned from the ListInferenceExecutions operation, including model used, inference scheduler, data configuration, and so on.

If you don't supply the InferenceSchedulerName request parameter, or if you supply the name of an inference scheduler that doesn't exist, ListInferenceExecutions returns an empty array in InferenceExecutionSummaries.

STRUCT(
    "model_name" VARCHAR,
    "model_arn" VARCHAR,
    "inference_scheduler_name" VARCHAR,
    "inference_scheduler_arn" VARCHAR,
    "scheduled_start_time" TIMESTAMP_S,
    "data_start_time" TIMESTAMP_S,
    "data_end_time" TIMESTAMP_S,
    "data_input_configuration" STRUCT(
        "s3_input_configuration" STRUCT(
            "bucket" VARCHAR,
            "prefix" VARCHAR
        ),
        "input_time_zone_offset" VARCHAR,
        "inference_input_name_configuration" STRUCT(
            "timestamp_format" VARCHAR,
            "component_timestamp_delimiter" VARCHAR
        )
    ),
    "data_output_configuration" STRUCT(
        "s3_output_configuration" STRUCT(
            "bucket" VARCHAR,
            "prefix" VARCHAR
        ),
        "kms_key_id" VARCHAR
    ),
    "customer_result_object" STRUCT(
        "bucket" VARCHAR,
        "key" VARCHAR
    ),
    "status" VARCHAR,
    "failed_reason" VARCHAR,
    "model_version" BIGINT,
    "model_version_arn" VARCHAR
)[]
Show child fields
inference_execution_summaries[]
Show child fields
inference_execution_summaries[].customer_result_object

The S3 object that the inference execution results were uploaded to.

Show child fields
inference_execution_summaries[].customer_result_object.bucket

The name of the specific S3 bucket.

inference_execution_summaries[].customer_result_object.key

The Amazon Web Services Key Management Service (KMS key) key being used to encrypt the S3 object. Without this key, data in the bucket is not accessible.

inference_execution_summaries[].data_end_time

Indicates the time reference in the dataset at which the inference execution stopped.

inference_execution_summaries[].data_input_configuration

Specifies configuration information for the input data for the inference scheduler, including delimiter, format, and dataset location.

Show child fields
inference_execution_summaries[].data_input_configuration.inference_input_name_configuration

Specifies configuration information for the input data for the inference, including timestamp format and delimiter.

Show child fields
inference_execution_summaries[].data_input_configuration.inference_input_name_configuration.component_timestamp_delimiter

Indicates the delimiter character used between items in the data.

inference_execution_summaries[].data_input_configuration.inference_input_name_configuration.timestamp_format

The format of the timestamp, whether Epoch time, or standard, with or without hyphens (-).

inference_execution_summaries[].data_input_configuration.input_time_zone_offset

Indicates the difference between your time zone and Coordinated Universal Time (UTC).

inference_execution_summaries[].data_input_configuration.s3_input_configuration

Specifies configuration information for the input data for the inference, including Amazon S3 location of input data.

Show child fields
inference_execution_summaries[].data_input_configuration.s3_input_configuration.bucket

The bucket containing the input dataset for the inference.

inference_execution_summaries[].data_input_configuration.s3_input_configuration.prefix

The prefix for the S3 bucket used for the input data for the inference.

inference_execution_summaries[].data_output_configuration

Specifies configuration information for the output results from for the inference execution, including the output Amazon S3 location.

Show child fields
inference_execution_summaries[].data_output_configuration.kms_key_id

The ID number for the KMS key key used to encrypt the inference output.

inference_execution_summaries[].data_output_configuration.s3_output_configuration

Specifies configuration information for the output results from for the inference, output S3 location.

Show child fields
inference_execution_summaries[].data_output_configuration.s3_output_configuration.bucket

The bucket containing the output results from the inference

inference_execution_summaries[].data_output_configuration.s3_output_configuration.prefix

The prefix for the S3 bucket used for the output results from the inference.

inference_execution_summaries[].data_start_time

Indicates the time reference in the dataset at which the inference execution began.

inference_execution_summaries[].failed_reason

Specifies the reason for failure when an inference execution has failed.

inference_execution_summaries[].inference_scheduler_arn

The Amazon Resource Name (ARN) of the inference scheduler being used for the inference execution.

inference_execution_summaries[].inference_scheduler_name

The name of the inference scheduler being used for the inference execution.

inference_execution_summaries[].model_arn

The Amazon Resource Name (ARN) of the machine learning model used for the inference execution.

inference_execution_summaries[].model_name

The name of the machine learning model being used for the inference execution.

inference_execution_summaries[].model_version

The model version used for the inference execution.

inference_execution_summaries[].model_version_arn

The Amazon Resource Number (ARN) of the model version used for the inference execution.

inference_execution_summaries[].scheduled_start_time

Indicates the start time at which the inference scheduler began the specific inference execution.

inference_execution_summaries[].status

Indicates the status of the inference execution.