aws.transcribe.list_call_analytics_categories

Example SQL Queries

SELECT * FROM
aws.transcribe.list_call_analytics_categories;

Description

Provides a list of Call Analytics categories, including all rules that make up each category.

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

• View All Transcribe Tables
• Boto3 Reference

Table Definition

Column Name	Column Data Type
max_results Input Column The maximum number of Call Analytics categories 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
_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
categories Provides detailed information about your Call Analytics categories, including all the rules associated with each category.	STRUCT( "category_name" VARCHAR, "rules" STRUCT( "non_talk_time_filter" STRUCT( "threshold" BIGINT, "absolute_time_range" STRUCT( "start_time" BIGINT, "end_time" BIGINT, "first" BIGINT, "last" BIGINT ), "relative_time_range" STRUCT( "start_percentage" BIGINT, "end_percentage" BIGINT, "first" BIGINT, "last" BIGINT ), "negate" BOOLEAN ), "interruption_filter" STRUCT( "threshold" BIGINT, "participant_role" VARCHAR, "absolute_time_range" STRUCT( "start_time" BIGINT, "end_time" BIGINT, "first" BIGINT, "last" BIGINT ), "relative_time_range" STRUCT( "start_percentage" BIGINT, "end_percentage" BIGINT, "first" BIGINT, "last" BIGINT ), "negate" BOOLEAN ), "transcript_filter" STRUCT( "transcript_filter_type" VARCHAR, "absolute_time_range" STRUCT( "start_time" BIGINT, "end_time" BIGINT, "first" BIGINT, "last" BIGINT ), "relative_time_range" STRUCT( "start_percentage" BIGINT, "end_percentage" BIGINT, "first" BIGINT, "last" BIGINT ), "participant_role" VARCHAR, "negate" BOOLEAN, "targets" VARCHAR[] ), "sentiment_filter" STRUCT( "sentiments" VARCHAR[], "absolute_time_range" STRUCT( "start_time" BIGINT, "end_time" BIGINT, "first" BIGINT, "last" BIGINT ), "relative_time_range" STRUCT( "start_percentage" BIGINT, "end_percentage" BIGINT, "first" BIGINT, "last" BIGINT ), "participant_role" VARCHAR, "negate" BOOLEAN ) )[], "create_time" TIMESTAMP_S, "last_update_time" TIMESTAMP_S, "input_type" VARCHAR )[]
Show child fields categories[] Show child fields categories[].category_name The name of the Call Analytics category. Category names are case sensitive and must be unique within an Amazon Web Services account. categories[].create_time The date and time the specified Call Analytics category was created. 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 12:32 PM UTC-7 on May 4, 2022. categories[].input_type The input type associated with the specified category. POST_CALL refers to a category that is applied to batch transcriptions; REAL_TIME refers to a category that is applied to streaming transcriptions. categories[].last_update_time The date and time the specified Call Analytics category was last updated. Timestamps are in the format YYYY-MM-DD'T'HH:MM:SS.SSSSSS-UTC. For example, 2022-05-05T12:45:32.691000-07:00 represents 12:45 PM UTC-7 on May 5, 2022. categories[].rules[] Show child fields categories[].rules[].interruption_filter Flag the presence or absence of interruptions in your Call Analytics transcription output. Refer to for more detail. Show child fields categories[].rules[].interruption_filter.absolute_time_range Makes it possible to specify a time range (in milliseconds) in your audio, during which you want to search for an interruption. See for more detail. Show child fields categories[].rules[].interruption_filter.absolute_time_range.end_time The time, in milliseconds, when Amazon Transcribe stops searching for the specified criteria in your audio. If you include EndTime in your request, you must also include StartTime. categories[].rules[].interruption_filter.absolute_time_range.first The time, in milliseconds, from the start of your media file until the specified value. Amazon Transcribe searches for your specified criteria in this time segment. categories[].rules[].interruption_filter.absolute_time_range.last The time, in milliseconds, from the specified value until the end of your media file. Amazon Transcribe searches for your specified criteria in this time segment. categories[].rules[].interruption_filter.absolute_time_range.start_time The time, in milliseconds, when Amazon Transcribe starts searching for the specified criteria in your audio. If you include StartTime in your request, you must also include EndTime. categories[].rules[].interruption_filter.negate Set to TRUE to flag speech that does not contain interruptions. Set to FALSE to flag speech that contains interruptions. categories[].rules[].interruption_filter.participant_role Specify the interrupter that you want to flag. Omitting this parameter is equivalent to specifying both participants. categories[].rules[].interruption_filter.relative_time_range Makes it possible to specify a time range (in percentage) in your media file, during which you want to search for an interruption. See for more detail. Show child fields categories[].rules[].interruption_filter.relative_time_range.end_percentage The time, in percentage, when Amazon Transcribe stops searching for the specified criteria in your media file. If you include EndPercentage in your request, you must also include StartPercentage. categories[].rules[].interruption_filter.relative_time_range.first The time, in percentage, from the start of your media file until the specified value. Amazon Transcribe searches for your specified criteria in this time segment. categories[].rules[].interruption_filter.relative_time_range.last The time, in percentage, from the specified value until the end of your media file. Amazon Transcribe searches for your specified criteria in this time segment. categories[].rules[].interruption_filter.relative_time_range.start_percentage The time, in percentage, when Amazon Transcribe starts searching for the specified criteria in your media file. If you include StartPercentage in your request, you must also include EndPercentage. categories[].rules[].interruption_filter.threshold Specify the duration of the interruptions in milliseconds. For example, you can flag speech that contains more than 10,000 milliseconds of interruptions. categories[].rules[].non_talk_time_filter Flag the presence or absence of periods of silence in your Call Analytics transcription output. Refer to for more detail. Show child fields categories[].rules[].non_talk_time_filter.absolute_time_range Makes it possible to specify a time range (in milliseconds) in your audio, during which you want to search for a period of silence. See for more detail. Show child fields categories[].rules[].non_talk_time_filter.absolute_time_range.end_time The time, in milliseconds, when Amazon Transcribe stops searching for the specified criteria in your audio. If you include EndTime in your request, you must also include StartTime. categories[].rules[].non_talk_time_filter.absolute_time_range.first The time, in milliseconds, from the start of your media file until the specified value. Amazon Transcribe searches for your specified criteria in this time segment. categories[].rules[].non_talk_time_filter.absolute_time_range.last The time, in milliseconds, from the specified value until the end of your media file. Amazon Transcribe searches for your specified criteria in this time segment. categories[].rules[].non_talk_time_filter.absolute_time_range.start_time The time, in milliseconds, when Amazon Transcribe starts searching for the specified criteria in your audio. If you include StartTime in your request, you must also include EndTime. categories[].rules[].non_talk_time_filter.negate Set to TRUE to flag periods of speech. Set to FALSE to flag periods of silence categories[].rules[].non_talk_time_filter.relative_time_range Makes it possible to specify a time range (in percentage) in your media file, during which you want to search for a period of silence. See for more detail. Show child fields categories[].rules[].non_talk_time_filter.relative_time_range.end_percentage The time, in percentage, when Amazon Transcribe stops searching for the specified criteria in your media file. If you include EndPercentage in your request, you must also include StartPercentage. categories[].rules[].non_talk_time_filter.relative_time_range.first The time, in percentage, from the start of your media file until the specified value. Amazon Transcribe searches for your specified criteria in this time segment. categories[].rules[].non_talk_time_filter.relative_time_range.last The time, in percentage, from the specified value until the end of your media file. Amazon Transcribe searches for your specified criteria in this time segment. categories[].rules[].non_talk_time_filter.relative_time_range.start_percentage The time, in percentage, when Amazon Transcribe starts searching for the specified criteria in your media file. If you include StartPercentage in your request, you must also include EndPercentage. categories[].rules[].non_talk_time_filter.threshold Specify the duration, in milliseconds, of the period of silence that you want to flag. For example, you can flag a silent period that lasts 30,000 milliseconds. categories[].rules[].sentiment_filter Flag the presence or absence of specific sentiments in your Call Analytics transcription output. Refer to for more detail. Show child fields categories[].rules[].sentiment_filter.absolute_time_range Makes it possible to specify a time range (in milliseconds) in your audio, during which you want to search for the specified sentiments. See for more detail. Show child fields categories[].rules[].sentiment_filter.absolute_time_range.end_time The time, in milliseconds, when Amazon Transcribe stops searching for the specified criteria in your audio. If you include EndTime in your request, you must also include StartTime. categories[].rules[].sentiment_filter.absolute_time_range.first The time, in milliseconds, from the start of your media file until the specified value. Amazon Transcribe searches for your specified criteria in this time segment. categories[].rules[].sentiment_filter.absolute_time_range.last The time, in milliseconds, from the specified value until the end of your media file. Amazon Transcribe searches for your specified criteria in this time segment. categories[].rules[].sentiment_filter.absolute_time_range.start_time The time, in milliseconds, when Amazon Transcribe starts searching for the specified criteria in your audio. If you include StartTime in your request, you must also include EndTime. categories[].rules[].sentiment_filter.negate Set to TRUE to flag the sentiments that you didn't include in your request. Set to FALSE to flag the sentiments that you specified in your request. categories[].rules[].sentiment_filter.participant_role Specify the participant that you want to flag. Omitting this parameter is equivalent to specifying both participants. categories[].rules[].sentiment_filter.relative_time_range Makes it possible to specify a time range (in percentage) in your media file, during which you want to search for the specified sentiments. See for more detail. Show child fields categories[].rules[].sentiment_filter.relative_time_range.end_percentage The time, in percentage, when Amazon Transcribe stops searching for the specified criteria in your media file. If you include EndPercentage in your request, you must also include StartPercentage. categories[].rules[].sentiment_filter.relative_time_range.first The time, in percentage, from the start of your media file until the specified value. Amazon Transcribe searches for your specified criteria in this time segment. categories[].rules[].sentiment_filter.relative_time_range.last The time, in percentage, from the specified value until the end of your media file. Amazon Transcribe searches for your specified criteria in this time segment. categories[].rules[].sentiment_filter.relative_time_range.start_percentage The time, in percentage, when Amazon Transcribe starts searching for the specified criteria in your media file. If you include StartPercentage in your request, you must also include EndPercentage. categories[].rules[].sentiment_filter.sentiments[] categories[].rules[].transcript_filter Flag the presence or absence of specific words or phrases in your Call Analytics transcription output. Refer to for more detail. Show child fields categories[].rules[].transcript_filter.absolute_time_range Makes it possible to specify a time range (in milliseconds) in your audio, during which you want to search for the specified key words or phrases. See for more detail. Show child fields categories[].rules[].transcript_filter.absolute_time_range.end_time The time, in milliseconds, when Amazon Transcribe stops searching for the specified criteria in your audio. If you include EndTime in your request, you must also include StartTime. categories[].rules[].transcript_filter.absolute_time_range.first The time, in milliseconds, from the start of your media file until the specified value. Amazon Transcribe searches for your specified criteria in this time segment. categories[].rules[].transcript_filter.absolute_time_range.last The time, in milliseconds, from the specified value until the end of your media file. Amazon Transcribe searches for your specified criteria in this time segment. categories[].rules[].transcript_filter.absolute_time_range.start_time The time, in milliseconds, when Amazon Transcribe starts searching for the specified criteria in your audio. If you include StartTime in your request, you must also include EndTime. categories[].rules[].transcript_filter.negate Set to TRUE to flag the absence of the phrase that you specified in your request. Set to FALSE to flag the presence of the phrase that you specified in your request. categories[].rules[].transcript_filter.participant_role Specify the participant that you want to flag. Omitting this parameter is equivalent to specifying both participants. categories[].rules[].transcript_filter.relative_time_range Makes it possible to specify a time range (in percentage) in your media file, during which you want to search for the specified key words or phrases. See for more detail. Show child fields categories[].rules[].transcript_filter.relative_time_range.end_percentage The time, in percentage, when Amazon Transcribe stops searching for the specified criteria in your media file. If you include EndPercentage in your request, you must also include StartPercentage. categories[].rules[].transcript_filter.relative_time_range.first The time, in percentage, from the start of your media file until the specified value. Amazon Transcribe searches for your specified criteria in this time segment. categories[].rules[].transcript_filter.relative_time_range.last The time, in percentage, from the specified value until the end of your media file. Amazon Transcribe searches for your specified criteria in this time segment. categories[].rules[].transcript_filter.relative_time_range.start_percentage The time, in percentage, when Amazon Transcribe starts searching for the specified criteria in your media file. If you include StartPercentage in your request, you must also include EndPercentage. categories[].rules[].transcript_filter.targets[] categories[].rules[].transcript_filter.transcript_filter_type Flag the presence or absence of an exact match to the phrases that you specify. For example, if you specify the phrase "speak to a manager" as your Targets value, only that exact phrase is flagged. Note that semantic matching is not supported. For example, if your customer says "speak to the manager", instead of "speak to a manager", your content is not flagged.

Note

Tables may require input columns to have values specified before the table can return it’s rows. The values for input parameters are set in the where clause of the query typically using = or IN.