Skip to content

aws.transcribe.list_call_analytics_jobs

Example SQL Queries

SELECT * FROM
aws.transcribe.list_call_analytics_jobs;

Description

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

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

Table Definition

Column NameColumn Data Type
job_name_contains Input Column

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

VARCHAR
max_results Input Column

The maximum number of Call Analytics 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 Call Analytics 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
call_analytics_job_summaries

Provides a summary of information about each result.

STRUCT(
"call_analytics_job_name" VARCHAR,
"creation_time" TIMESTAMP_S,
"start_time" TIMESTAMP_S,
"completion_time" TIMESTAMP_S,
"language_code" VARCHAR,
"call_analytics_job_status" VARCHAR,
"call_analytics_job_details" STRUCT(
"skipped" STRUCT(
"feature" VARCHAR,
"reason_code" VARCHAR,
"message" VARCHAR
)[]
),
"failure_reason" VARCHAR
)[]
Show child fields
call_analytics_job_summaries[]
Show child fields
call_analytics_job_summaries[].call_analytics_job_details

Provides detailed information about a call analytics job, including information about skipped analytics features.

Show child fields
call_analytics_job_summaries[].call_analytics_job_details.skipped[]
Show child fields
call_analytics_job_summaries[].call_analytics_job_details.skipped[].feature

Indicates the type of analytics feature that was skipped during the analysis of a call analytics job.

call_analytics_job_summaries[].call_analytics_job_details.skipped[].message

Contains additional information or a message explaining why a specific analytics feature was skipped during the analysis of a call analytics job.

call_analytics_job_summaries[].call_analytics_job_details.skipped[].reason_code

Provides a code indicating the reason why a specific analytics feature was skipped during the analysis of a call analytics job.

call_analytics_job_summaries[].call_analytics_job_name

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

call_analytics_job_summaries[].call_analytics_job_status

Provides the status of your Call Analytics 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.

call_analytics_job_summaries[].completion_time

The date and time the specified Call Analytics 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.

call_analytics_job_summaries[].creation_time

The date and time the specified Call Analytics 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.

call_analytics_job_summaries[].failure_reason

If CallAnalyticsJobStatus is FAILED, FailureReason contains information about why the Call Analytics job failed. See also: Common Errors.

call_analytics_job_summaries[].language_code

The language code used to create your Call Analytics transcription.

call_analytics_job_summaries[].start_time

The date and time your Call Analytics 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.