Skip to content

aws.rekognition.get_media_analysis_job

Example SQL Queries

SELECT * FROM
aws.rekognition.get_media_analysis_job
WHERE
"job_id" = 'VALUE';

Description

Retrieves the results for a given media analysis job. Takes a JobId returned by StartMediaAnalysisJob.

Table Definition

Column NameColumn Data Type
job_id Required Input Column

The identifier for the media analysis job.

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
completion_timestamp

The Unix date and time when the job finished.

TIMESTAMP_S
creation_timestamp

The Unix date and time when the job was started.

TIMESTAMP_S
failure_details

Details about the error that resulted in failure of the job.

STRUCT(
"code" VARCHAR,
"message" VARCHAR
)
Show child fields
failure_details.code

Error code for the failed job.

failure_details.message

Human readable error message.

input

Reference to the input manifest that was provided in the job creation request.

STRUCT(
"s3_object" STRUCT(
"bucket" VARCHAR,
"name" VARCHAR,
"version" VARCHAR
)
)
Show child fields
input.s3_object

Provides the S3 bucket name and object name.

The region for the S3 bucket containing the S3 object must match the region you use for Amazon Rekognition operations.

For Amazon Rekognition to process an S3 object, the user must have permission to access the S3 object. For more information, see How Amazon Rekognition works with IAM in the Amazon Rekognition Developer Guide.

Show child fields
input.s3_object.bucket

Name of the S3 bucket.

input.s3_object.name

S3 object key name.

input.s3_object.version

If the bucket is versioning enabled, you can specify the object version.

job_name

The name of the media analysis job.

VARCHAR
kms_key_id

KMS Key that was provided in the creation request.

VARCHAR
manifest_summary

The summary manifest provides statistics on input manifest and errors identified in the input manifest.

STRUCT(
"s3_object" STRUCT(
"bucket" VARCHAR,
"name" VARCHAR,
"version" VARCHAR
)
)
Show child fields
manifest_summary.s3_object

Provides the S3 bucket name and object name.

The region for the S3 bucket containing the S3 object must match the region you use for Amazon Rekognition operations.

For Amazon Rekognition to process an S3 object, the user must have permission to access the S3 object. For more information, see How Amazon Rekognition works with IAM in the Amazon Rekognition Developer Guide.

Show child fields
manifest_summary.s3_object.bucket

Name of the S3 bucket.

manifest_summary.s3_object.name

S3 object key name.

manifest_summary.s3_object.version

If the bucket is versioning enabled, you can specify the object version.

operations_config

Operation configurations that were provided during job creation.

STRUCT(
"detect_moderation_labels" STRUCT(
"min_confidence" DOUBLE,
"project_version" VARCHAR
)
)
Show child fields
operations_config.detect_moderation_labels

Contains configuration options for a DetectModerationLabels job.

Show child fields
operations_config.detect_moderation_labels.min_confidence

Specifies the minimum confidence level for the moderation labels to return. Amazon Rekognition doesn't return any labels with a confidence level lower than this specified value.

operations_config.detect_moderation_labels.project_version

Specifies the custom moderation model to be used during the label detection job. If not provided the pre-trained model is used.

output_config

Output configuration that was provided in the creation request.

STRUCT(
"s3_bucket" VARCHAR,
"s3_key_prefix" VARCHAR
)
Show child fields
output_config.s3_bucket

Specifies the Amazon S3 bucket to contain the output of the media analysis job.

output_config.s3_key_prefix

Specifies the Amazon S3 key prefix that comes after the name of the bucket you have designated for storage.

results

Output manifest that contains prediction results.

STRUCT(
"s3_object" STRUCT(
"bucket" VARCHAR,
"name" VARCHAR,
"version" VARCHAR
),
"model_versions" STRUCT(
"moderation" VARCHAR
)
)
Show child fields
results.model_versions

Information about the model versions for the features selected in a given job.

Show child fields
results.model_versions.moderation

The Moderation base model version.

results.s3_object

Provides the S3 bucket name and object name.

The region for the S3 bucket containing the S3 object must match the region you use for Amazon Rekognition operations.

For Amazon Rekognition to process an S3 object, the user must have permission to access the S3 object. For more information, see How Amazon Rekognition works with IAM in the Amazon Rekognition Developer Guide.

Show child fields
results.s3_object.bucket

Name of the S3 bucket.

results.s3_object.name

S3 object key name.

results.s3_object.version

If the bucket is versioning enabled, you can specify the object version.

status

The current status of the media analysis job.

VARCHAR