Skip to content
AWS for Query.Farm

aws.machinelearning.get_batch_prediction

Example SQL Queries

SELECT * FROM
aws.machinelearning.get_batch_prediction
WHERE
"batch_prediction_id" = 'VALUE';

Description

Returns a BatchPrediction that includes detailed metadata, status, and data file information for a Batch Prediction request.

Table Definition

Column NameColumn Data Type
batch_prediction_id Required Input Column

An ID assigned to the BatchPrediction at creation. This value should be identical to the value of the BatchPredictionID in the request.

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
batch_prediction_data_source_id

The ID of the DataSource that was used to create the BatchPrediction. 

VARCHAR
compute_time

The approximate CPU time in milliseconds that Amazon Machine Learning spent processing the BatchPrediction, normalized and scaled on computation resources. ComputeTime is only available if the BatchPrediction is in the COMPLETED state.

BIGINT
created_at

The time when the BatchPrediction was created. The time is expressed in epoch time.

TIMESTAMP_S
created_by_iam_user

The AWS user account that invoked the BatchPrediction. The account type can be either an AWS root account or an AWS Identity and Access Management (IAM) user account.

VARCHAR
finished_at

The epoch time when Amazon Machine Learning marked the BatchPrediction as COMPLETED or FAILED. FinishedAt is only available when the BatchPrediction is in the COMPLETED or FAILED state.

TIMESTAMP_S
input_data_location_s3

The location of the data file or directory in Amazon Simple Storage Service (Amazon S3).

VARCHAR
invalid_record_count

The number of invalid records that Amazon Machine Learning saw while processing the BatchPrediction.

BIGINT
last_updated_at

The time of the most recent edit to BatchPrediction. The time is expressed in epoch time.

TIMESTAMP_S
log_uri

A link to the file that contains logs of the CreateBatchPrediction operation.

VARCHAR
message

A description of the most recent details about processing the batch prediction request.

VARCHAR
ml_model_id

The ID of the MLModel that generated predictions for the BatchPrediction request.

VARCHAR
name

A user-supplied name or description of the BatchPrediction.

VARCHAR
output_uri

The location of an Amazon S3 bucket or directory to receive the operation results.

VARCHAR
started_at

The epoch time when Amazon Machine Learning marked the BatchPrediction as INPROGRESS. StartedAt isn't available if the BatchPrediction is in the PENDING state.

TIMESTAMP_S
status

The status of the BatchPrediction, which can be one of the following values:

  • PENDING - Amazon Machine Learning (Amazon ML) submitted a request to generate batch predictions.

  • INPROGRESS - The batch predictions are in progress.

  • FAILED - The request to perform a batch prediction did not run to completion. It is not usable.

  • COMPLETED - The batch prediction process completed successfully.

  • DELETED - The BatchPrediction is marked as deleted. It is not usable.

VARCHAR
total_record_count

The number of total records that Amazon Machine Learning saw while processing the BatchPrediction.

BIGINT