Skip to content
AWS for Query.Farm

aws.s3control.list_jobs

Example SQL Queries

SELECT * FROM
aws.s3control.list_jobs
WHERE
"account_id" = 'VALUE';

Description

Lists current S3 Batch Operations jobs as well as the jobs that have ended within the last 90 days for the Amazon Web Services account making the request. For more information, see S3 Batch Operations in the Amazon S3 User Guide.

Permissions

To use the ListJobs operation, you must have permission to perform the s3:ListJobs action.

Related actions include:

Table Definition

Column NameColumn Data Type
account_id Required Input Column

The Amazon Web Services account ID associated with the S3 Batch Operations job.

VARCHAR
job_statuses Input Column

The List Jobs request returns jobs that match the statuses listed in this element.

VARCHAR[]
Show child fields
job_statuses[]
max_results Input Column

The maximum number of jobs that Amazon S3 will include in the List Jobs response. If there are more jobs than this number, the response will include a pagination token in the NextToken field to enable you to retrieve the next page of results.

BIGINT
next_token Input Column

If the List Jobs request produced more than the maximum number of results, you can pass this value into a subsequent List Jobs request in order to retrieve the next page of results.

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.

jobs

The list of current jobs and jobs that have ended within the last 30 days.

STRUCT(
    "job_id" VARCHAR,
    "description" VARCHAR,
    "operation" VARCHAR,
    "priority" BIGINT,
    "status" VARCHAR,
    "creation_time" TIMESTAMP_S,
    "termination_date" TIMESTAMP_S,
    "progress_summary" STRUCT(
        "total_number_of_tasks" BIGINT,
        "number_of_tasks_succeeded" BIGINT,
        "number_of_tasks_failed" BIGINT,
        "timers" STRUCT(
            "elapsed_time_in_active_seconds" BIGINT
        )
    )
)[]
Show child fields
jobs[]
Show child fields
jobs[].creation_time

A timestamp indicating when the specified job was created.

jobs[].description

The user-specified description that was included in the specified job's Create Job request.

jobs[].job_id

The ID for the specified job.

jobs[].operation

The operation that the specified job is configured to run on every object listed in the manifest.

jobs[].priority

The current priority for the specified job.

jobs[].progress_summary

Describes the total number of tasks that the specified job has run, the number of tasks that succeeded, and the number of tasks that failed.

Show child fields
jobs[].progress_summary.number_of_tasks_failed

jobs[].progress_summary.number_of_tasks_succeeded

jobs[].progress_summary.timers

The JobTimers attribute of a job's progress summary.

Show child fields
jobs[].progress_summary.timers.elapsed_time_in_active_seconds

Indicates the elapsed time in seconds the job has been in the Active job state.

jobs[].progress_summary.total_number_of_tasks

jobs[].status

The specified job's current status.

jobs[].termination_date

A timestamp indicating when the specified job terminated. A job's termination date is the date and time when it succeeded, failed, or was canceled.