Skip to content
AWS for Query.Farm

aws.lookoutequipment.list_inference_events

Example SQL Queries

SELECT * FROM
aws.lookoutequipment.list_inference_events
WHERE
"inference_scheduler_name" = 'VALUE'
AND "interval_start_time" = 'VALUE'
AND "interval_end_time" = 'VALUE';

Description

Lists all inference events that have been found for 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 events listed. 

VARCHAR
interval_end_time Required Input Column

Returns all the inference events with an end start time equal to or greater than less than the end time given.

TIMESTAMP_S
interval_start_time Required Input Column

Lookout for Equipment will return all the inference events with an end time equal to or greater than the start time given.

TIMESTAMP_S
max_results Input Column

Specifies the maximum number of inference events to list. 

BIGINT
next_token Input Column

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

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_event_summaries

Provides an array of information about the individual inference events returned from the ListInferenceEvents operation, including scheduler used, event start time, event end time, diagnostics, and so on. 

STRUCT(
    "inference_scheduler_arn" VARCHAR,
    "inference_scheduler_name" VARCHAR,
    "event_start_time" TIMESTAMP_S,
    "event_end_time" TIMESTAMP_S,
    "diagnostics" VARCHAR,
    "event_duration_in_seconds" BIGINT
)[]
Show child fields
inference_event_summaries[]
Show child fields
inference_event_summaries[].diagnostics

An array which specifies the names and values of all sensors contributing to an inference event.

inference_event_summaries[].event_duration_in_seconds

Indicates the size of an inference event in seconds.

inference_event_summaries[].event_end_time

Indicates the ending time of an inference event.

inference_event_summaries[].event_start_time

Indicates the starting time of an inference event.

inference_event_summaries[].inference_scheduler_arn

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

inference_event_summaries[].inference_scheduler_name

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