Skip to content

aws.transcribe.list_transcription_jobs

Example SQL Queries

SELECT * FROM
aws.transcribe.list_transcription_jobs;

Description

Provides a list of transcription jobs that match the specified criteria. If no criteria are specified, all transcription jobs are returned.

To get detailed information about a specific transcription job, use the operation.

Table Definition

Column NameColumn Data Type
job_name_contains Input Column

Returns only the transcription jobs that contain the specified string. The search is not case sensitive.

VARCHAR
max_results Input Column

The maximum number of transcription jobs to return in each page of results. If there are fewer results than the value that you specify, only the actual results are returned. If you do not specify a value, a default of 5 is used.

BIGINT
next_token Input Column

If NextToken is present in your response, it indicates that not all results are displayed. To view the next set of results, copy the string associated with the NextToken parameter in your results output, then run your request again including NextToken with the value of the copied string. Repeat as needed to view all your results.

VARCHAR
status Input Column

Lists all transcription jobs that have the status specified in your request. Jobs are ordered by creation date, with the newest job first.

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
transcription_job_summaries

Provides a summary of information about each result.

STRUCT(
"transcription_job_name" VARCHAR,
"creation_time" TIMESTAMP_S,
"start_time" TIMESTAMP_S,
"completion_time" TIMESTAMP_S,
"language_code" VARCHAR,
"transcription_job_status" VARCHAR,
"failure_reason" VARCHAR,
"output_location_type" VARCHAR,
"content_redaction" STRUCT(
"redaction_type" VARCHAR,
"redaction_output" VARCHAR,
"pii_entity_types" VARCHAR[]
),
"model_settings" STRUCT(
"language_model_name" VARCHAR
),
"identify_language" BOOLEAN,
"identify_multiple_languages" BOOLEAN,
"identified_language_score" DOUBLE,
"language_codes" STRUCT(
"language_code" VARCHAR,
"duration_in_seconds" DOUBLE
)[],
"toxicity_detection" STRUCT(
"toxicity_categories" VARCHAR[]
)[]
)[]
Show child fields
transcription_job_summaries[]
Show child fields
transcription_job_summaries[].completion_time

The date and time the specified transcription job finished processing.

Timestamps are in the format YYYY-MM-DD'T'HH:MM:SS.SSSSSS-UTC. For example, 2022-05-04T12:33:13.922000-07:00 represents a transcription job that started processing at 12:33 PM UTC-7 on May 4, 2022.

transcription_job_summaries[].content_redaction

The content redaction settings of the transcription job.

Show child fields
transcription_job_summaries[].content_redaction.pii_entity_types[]
transcription_job_summaries[].content_redaction.redaction_output

Specify if you want only a redacted transcript, or if you want a redacted and an unredacted transcript.

When you choose redacted Amazon Transcribe creates only a redacted transcript.

When you choose redacted_and_unredacted Amazon Transcribe creates a redacted and an unredacted transcript (as two separate files).

transcription_job_summaries[].content_redaction.redaction_type

Specify the category of information you want to redact; PII (personally identifiable information) is the only valid value. You can use PiiEntityTypes to choose which types of PII you want to redact. If you do not include PiiEntityTypes in your request, all PII is redacted.

transcription_job_summaries[].creation_time

The date and time the specified transcription job request was made.

Timestamps are in the format YYYY-MM-DD'T'HH:MM:SS.SSSSSS-UTC. For example, 2022-05-04T12:32:58.761000-07:00 represents a transcription job that started processing at 12:32 PM UTC-7 on May 4, 2022.

transcription_job_summaries[].failure_reason

If TranscriptionJobStatus is FAILED, FailureReason contains information about why the transcription job failed. See also: Common Errors.

transcription_job_summaries[].identified_language_score

The confidence score associated with the language identified in your media file.

Confidence scores are values between 0 and 1; a larger value indicates a higher probability that the identified language correctly matches the language spoken in your media.

transcription_job_summaries[].identify_language

Indicates whether automatic language identification was enabled (TRUE) for the specified transcription job.

transcription_job_summaries[].identify_multiple_languages

Indicates whether automatic multi-language identification was enabled (TRUE) for the specified transcription job.

transcription_job_summaries[].language_code

The language code used to create your transcription.

transcription_job_summaries[].language_codes[]
Show child fields
transcription_job_summaries[].language_codes[].duration_in_seconds

Provides the total time, in seconds, each identified language is spoken in your media.

transcription_job_summaries[].language_codes[].language_code

Provides the language code for each language identified in your media.

transcription_job_summaries[].model_settings

Provides the name of the custom language model that was included in the specified transcription job.

Only use ModelSettings with the LanguageModelName sub-parameter if you're not using automatic language identification (). If using LanguageIdSettings in your request, this parameter contains a LanguageModelName sub-parameter.

Show child fields
transcription_job_summaries[].model_settings.language_model_name

The name of the custom language model you want to use when processing your transcription job. Note that custom language model names are case sensitive.

The language of the specified custom language model must match the language code that you specify in your transcription request. If the languages do not match, the custom language model isn't applied. There are no errors or warnings associated with a language mismatch.

transcription_job_summaries[].output_location_type

Indicates where the specified transcription output is stored.

If the value is CUSTOMER_BUCKET, the location is the Amazon S3 bucket you specified using the OutputBucketName parameter in your request. If you also included OutputKey in your request, your output is located in the path you specified in your request.

If the value is SERVICE_BUCKET, the location is a service-managed Amazon S3 bucket. To access a transcript stored in a service-managed bucket, use the URI shown in the TranscriptFileUri or RedactedTranscriptFileUri field.

transcription_job_summaries[].start_time

The date and time your transcription job began processing.

Timestamps are in the format YYYY-MM-DD'T'HH:MM:SS.SSSSSS-UTC. For example, 2022-05-04T12:32:58.789000-07:00 represents a transcription job that started processing at 12:32 PM UTC-7 on May 4, 2022.

transcription_job_summaries[].toxicity_detection[]
Show child fields
transcription_job_summaries[].toxicity_detection[].toxicity_categories[]
transcription_job_summaries[].transcription_job_name

The name of the transcription job. Job names are case sensitive and must be unique within an Amazon Web Services account.

transcription_job_summaries[].transcription_job_status

Provides the status of your transcription job.

If the status is COMPLETED, the job is finished and you can find the results at the location specified in TranscriptFileUri (or RedactedTranscriptFileUri, if you requested transcript redaction). If the status is FAILED, FailureReason provides details on why your transcription job failed.