Skip to content

aws.sagemaker.list_labeling_jobs

Example SQL Queries

SELECT * FROM
aws.sagemaker.list_labeling_jobs;

Description

Gets a list of labeling jobs.

Table Definition

Column NameColumn Data Type
creation_time_after Input Column

A filter that returns only labeling jobs created after the specified time (timestamp).

TIMESTAMP_S
creation_time_before Input Column

A filter that returns only labeling jobs created before the specified time (timestamp).

TIMESTAMP_S
last_modified_time_after Input Column

A filter that returns only labeling jobs modified after the specified time (timestamp).

TIMESTAMP_S
last_modified_time_before Input Column

A filter that returns only labeling jobs modified before the specified time (timestamp).

TIMESTAMP_S
name_contains Input Column

A string in the labeling job name. This filter returns only labeling jobs whose name contains the specified string.

VARCHAR
sort_by Input Column

The field to sort results by. The default is CreationTime.

VARCHAR
sort_order Input Column

The sort order for results. The default is Ascending.

VARCHAR
status_equals Input Column

A filter that retrieves only labeling jobs with a specific status.

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.

annotation_consolidation_lambda_arn

The Amazon Resource Name (ARN) of the Lambda function used to consolidate the annotations from individual workers into a label for a data object. For more information, see Annotation Consolidation.

VARCHAR
creation_time

The date and time that the job was created (timestamp).

TIMESTAMP_S
failure_reason

If the LabelingJobStatus field is Failed, this field contains a description of the error.

VARCHAR
input_config

Input configuration for the labeling job.

STRUCT(
"data_source" STRUCT(
"s3_data_source" STRUCT(
"manifest_s3_uri" VARCHAR
),
"sns_data_source" STRUCT(
"sns_topic_arn" VARCHAR
)
),
"data_attributes" STRUCT(
"content_classifiers" VARCHAR[]
)
)
Show child fields
input_config.data_attributes

Attributes of the data specified by the customer.

Show child fields
input_config.data_attributes.content_classifiers[]
input_config.data_source

The location of the input data.

Show child fields
input_config.data_source.s3_data_source

The Amazon S3 location of the input data objects.

Show child fields
input_config.data_source.s3_data_source.manifest_s3_uri

The Amazon S3 location of the manifest file that describes the input data objects.

The input manifest file referenced in ManifestS3Uri must contain one of the following keys: source-ref or source. The value of the keys are interpreted as follows:

  • source-ref: The source of the object is the Amazon S3 object specified in the value. Use this value when the object is a binary object, such as an image.

  • source: The source of the object is the value. Use this value when the object is a text value.

If you are a new user of Ground Truth, it is recommended you review Use an Input Manifest File in the Amazon SageMaker Developer Guide to learn how to create an input manifest file.

input_config.data_source.sns_data_source

An Amazon SNS data source used for streaming labeling jobs. To learn more, see Send Data to a Streaming Labeling Job.

Show child fields
input_config.data_source.sns_data_source.sns_topic_arn

The Amazon SNS input topic Amazon Resource Name (ARN). Specify the ARN of the input topic you will use to send new data objects to a streaming labeling job.

label_counters

Counts showing the progress of the labeling job.

STRUCT(
"total_labeled" BIGINT,
"human_labeled" BIGINT,
"machine_labeled" BIGINT,
"failed_non_retryable_error" BIGINT,
"unlabeled" BIGINT
)
Show child fields
label_counters.failed_non_retryable_error

The total number of objects that could not be labeled due to an error.

label_counters.human_labeled

The total number of objects labeled by a human worker.

label_counters.machine_labeled

The total number of objects labeled by automated data labeling.

label_counters.total_labeled

The total number of objects labeled.

label_counters.unlabeled

The total number of objects not yet labeled.

labeling_job_arn

The Amazon Resource Name (ARN) assigned to the labeling job when it was created.

VARCHAR
labeling_job_name

The name of the labeling job.

VARCHAR
labeling_job_output

The location of the output produced by the labeling job.

STRUCT(
"output_dataset_s3_uri" VARCHAR,
"final_active_learning_model_arn" VARCHAR
)
Show child fields
labeling_job_output.final_active_learning_model_arn

The Amazon Resource Name (ARN) for the most recent SageMaker model trained as part of automated data labeling.

labeling_job_output.output_dataset_s3_uri

The Amazon S3 bucket location of the manifest file for labeled data.

labeling_job_status

The current status of the labeling job.

VARCHAR
last_modified_time

The date and time that the job was last modified (timestamp).

TIMESTAMP_S
pre_human_task_lambda_arn

The Amazon Resource Name (ARN) of a Lambda function. The function is run before each data object is sent to a worker.

VARCHAR
workteam_arn

The Amazon Resource Name (ARN) of the work team assigned to the job.

VARCHAR