Skip to content
AWS for Query.Farm

aws.rekognition.list_media_analysis_jobs

Example SQL Queries

SELECT * FROM
aws.rekognition.list_media_analysis_jobs;

Description

Returns a list of media analysis jobs. Results are sorted by CreationTimestamp in descending order.

Table Definition

Column NameColumn Data Type
max_results Input Column

The maximum number of results to return per paginated call. The largest value user can specify is 100. If user specifies a value greater than 100, an InvalidParameterException error occurs. The default value is 100.

BIGINT
next_token Input Column

Pagination token, if the previous response was incomplete.

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
media_analysis_jobs

Contains a list of all media analysis jobs.

STRUCT(
    "job_id" VARCHAR,
    "job_name" VARCHAR,
    "operations_config" STRUCT(
        "detect_moderation_labels" STRUCT(
            "min_confidence" DOUBLE,
            "project_version" VARCHAR
        )
    ),
    "status" VARCHAR,
    "failure_details" STRUCT(
        "code" VARCHAR,
        "message" VARCHAR
    ),
    "creation_timestamp" TIMESTAMP_S,
    "completion_timestamp" TIMESTAMP_S,
    "input" STRUCT(
        "s3_object" STRUCT(
            "bucket" VARCHAR,
            "name" VARCHAR,
            "version" VARCHAR
        )
    ),
    "output_config" STRUCT(
        "s3_bucket" VARCHAR,
        "s3_key_prefix" VARCHAR
    ),
    "kms_key_id" VARCHAR,
    "results" STRUCT(
        "s3_object" STRUCT(
            "bucket" VARCHAR,
            "name" VARCHAR,
            "version" VARCHAR
        ),
        "model_versions" STRUCT(
            "moderation" VARCHAR
        )
    ),
    "manifest_summary" STRUCT(
        "s3_object" STRUCT(
            "bucket" VARCHAR,
            "name" VARCHAR,
            "version" VARCHAR
        )
    )
)[]
Show child fields
media_analysis_jobs[]
Show child fields
media_analysis_jobs[].completion_timestamp

The Unix date and time when the job finished.

media_analysis_jobs[].creation_timestamp

The Unix date and time when the job was started.

media_analysis_jobs[].failure_details

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

Show child fields
media_analysis_jobs[].failure_details.code

Error code for the failed job.

media_analysis_jobs[].failure_details.message

Human readable error message.

media_analysis_jobs[].input

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

Show child fields
media_analysis_jobs[].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
media_analysis_jobs[].input.s3_object.bucket

Name of the S3 bucket.

media_analysis_jobs[].input.s3_object.name

S3 object key name.

media_analysis_jobs[].input.s3_object.version

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

media_analysis_jobs[].job_id

The identifier for a media analysis job.

media_analysis_jobs[].job_name

The name of a media analysis job.

media_analysis_jobs[].kms_key_id

KMS Key that was provided in the creation request.

media_analysis_jobs[].manifest_summary

Provides statistics on input manifest and errors identified in the input manifest.

Show child fields
media_analysis_jobs[].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
media_analysis_jobs[].manifest_summary.s3_object.bucket

Name of the S3 bucket.

media_analysis_jobs[].manifest_summary.s3_object.name

S3 object key name.

media_analysis_jobs[].manifest_summary.s3_object.version

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

media_analysis_jobs[].operations_config

Operation configurations that were provided during job creation.

Show child fields
media_analysis_jobs[].operations_config.detect_moderation_labels

Contains configuration options for a DetectModerationLabels job.

Show child fields
media_analysis_jobs[].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.

media_analysis_jobs[].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.

media_analysis_jobs[].output_config

Output configuration that was provided in the creation request.

Show child fields
media_analysis_jobs[].output_config.s3_bucket

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

media_analysis_jobs[].output_config.s3_key_prefix

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

media_analysis_jobs[].results

Output manifest that contains prediction results.

Show child fields
media_analysis_jobs[].results.model_versions

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

Show child fields
media_analysis_jobs[].results.model_versions.moderation

The Moderation base model version.

media_analysis_jobs[].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
media_analysis_jobs[].results.s3_object.bucket

Name of the S3 bucket.

media_analysis_jobs[].results.s3_object.name

S3 object key name.

media_analysis_jobs[].results.s3_object.version

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

media_analysis_jobs[].status

The status of the media analysis job being retrieved.