Skip to content

aws.chime_sdk_media_pipelines.get_media_insights_pipeline_configuration

Example SQL Queries

SELECT * FROM
aws.chime_sdk_media_pipelines.get_media_insights_pipeline_configuration
WHERE
"identifier" = 'VALUE';

Description

Gets the configuration settings for a media insights pipeline.

Table Definition

Column NameColumn Data Type
identifier Required Input Column

The unique identifier of the requested resource. Valid values include the name and ARN of the media insights pipeline configuration.

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.

media_insights_pipeline_configuration

The requested media insights pipeline configuration.

STRUCT(
"media_insights_pipeline_configuration_name" VARCHAR,
"media_insights_pipeline_configuration_arn" VARCHAR,
"resource_access_role_arn" VARCHAR,
"real_time_alert_configuration" STRUCT(
"disabled" BOOLEAN,
"rules" STRUCT(
"type" VARCHAR,
"keyword_match_configuration" STRUCT(
"rule_name" VARCHAR,
"keywords" VARCHAR[],
"negate" BOOLEAN
),
"sentiment_configuration" STRUCT(
"rule_name" VARCHAR,
"sentiment_type" VARCHAR,
"time_period" BIGINT
),
"issue_detection_configuration" STRUCT(
"rule_name" VARCHAR
)
)[]
),
"elements" STRUCT(
"type" VARCHAR,
"amazon_transcribe_call_analytics_processor_configuration" STRUCT(
"language_code" VARCHAR,
"vocabulary_name" VARCHAR,
"vocabulary_filter_name" VARCHAR,
"vocabulary_filter_method" VARCHAR,
"language_model_name" VARCHAR,
"enable_partial_results_stabilization" BOOLEAN,
"partial_results_stability" VARCHAR,
"content_identification_type" VARCHAR,
"content_redaction_type" VARCHAR,
"pii_entity_types" VARCHAR,
"filter_partial_results" BOOLEAN,
"post_call_analytics_settings" STRUCT(
"output_location" VARCHAR,
"data_access_role_arn" VARCHAR,
"content_redaction_output" VARCHAR,
"output_encryption_kms_key_id" VARCHAR
),
"call_analytics_stream_categories" VARCHAR[]
),
"amazon_transcribe_processor_configuration" STRUCT(
"language_code" VARCHAR,
"vocabulary_name" VARCHAR,
"vocabulary_filter_name" VARCHAR,
"vocabulary_filter_method" VARCHAR,
"show_speaker_label" BOOLEAN,
"enable_partial_results_stabilization" BOOLEAN,
"partial_results_stability" VARCHAR,
"content_identification_type" VARCHAR,
"content_redaction_type" VARCHAR,
"pii_entity_types" VARCHAR,
"language_model_name" VARCHAR,
"filter_partial_results" BOOLEAN,
"identify_language" BOOLEAN,
"identify_multiple_languages" BOOLEAN,
"language_options" VARCHAR,
"preferred_language" VARCHAR,
"vocabulary_names" VARCHAR,
"vocabulary_filter_names" VARCHAR
),
"kinesis_data_stream_sink_configuration" STRUCT(
"insights_target" VARCHAR
),
"s3_recording_sink_configuration" STRUCT(
"destination" VARCHAR,
"recording_file_format" VARCHAR
),
"voice_analytics_processor_configuration" STRUCT(
"speaker_search_status" VARCHAR,
"voice_tone_analysis_status" VARCHAR
),
"lambda_function_sink_configuration" STRUCT(
"insights_target" VARCHAR
),
"sqs_queue_sink_configuration" STRUCT(
"insights_target" VARCHAR
),
"sns_topic_sink_configuration" STRUCT(
"insights_target" VARCHAR
),
"voice_enhancement_sink_configuration" STRUCT(
"disabled" BOOLEAN
)
)[],
"media_insights_pipeline_configuration_id" VARCHAR,
"created_timestamp" TIMESTAMP_S,
"updated_timestamp" TIMESTAMP_S
)
Show child fields
media_insights_pipeline_configuration.created_timestamp

The time at which the configuration was created.

media_insights_pipeline_configuration.elements[]
Show child fields
media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration

The analytics configuration settings for transcribing audio in a media insights pipeline configuration element.

Show child fields
media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration.call_analytics_stream_categories[]
media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration.content_identification_type

Labels all personally identifiable information (PII) identified in your transcript.

Content identification is performed at the segment level; PII specified in PiiEntityTypes is flagged upon complete transcription of an audio segment.

You can’t set ContentIdentificationType and ContentRedactionType in the same request. If you do, your request returns a BadRequestException.

For more information, see Redacting or identifying personally identifiable information in the Amazon Transcribe Developer Guide.

media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration.content_redaction_type

Redacts all personally identifiable information (PII) identified in your transcript.

Content redaction is performed at the segment level; PII specified in PiiEntityTypes is redacted upon complete transcription of an audio segment.

You can’t set ContentRedactionType and ContentIdentificationType in the same request. If you do, your request returns a BadRequestException.

For more information, see Redacting or identifying personally identifiable information in the Amazon Transcribe Developer Guide.

media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration.enable_partial_results_stabilization

Enables partial result stabilization for your transcription. Partial result stabilization can reduce latency in your output, but may impact accuracy. For more information, see Partial-result stabilization in the Amazon Transcribe Developer Guide.

media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration.filter_partial_results

If true, UtteranceEvents with IsPartial: true are filtered out of the insights target.

media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration.language_code

The language code in the configuration.

media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration.language_model_name

Specifies the name of the custom language model to use when processing a transcription. Note that language model names are case sensitive.

The language of the specified language model must match the language code specified in the transcription request. If the languages don't match, the custom language model isn't applied. Language mismatches don't generate errors or warnings.

For more information, see Custom language models in the Amazon Transcribe Developer Guide.

media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration.partial_results_stability

Specifies the level of stability to use when you enable partial results stabilization (EnablePartialResultsStabilization).

Low stability provides the highest accuracy. High stability transcribes faster, but with slightly lower accuracy.

For more information, see Partial-result stabilization in the Amazon Transcribe Developer Guide.

media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration.pii_entity_types

Specifies the types of personally identifiable information (PII) to redact from a transcript. You can include as many types as you'd like, or you can select ALL.

To include PiiEntityTypes in your Call Analytics request, you must also include ContentIdentificationType or ContentRedactionType, but you can't include both.

Values must be comma-separated and can include: ADDRESS, BANK_ACCOUNT_NUMBER, BANK_ROUTING, CREDIT_DEBIT_CVV, CREDIT_DEBIT_EXPIRY, CREDIT_DEBIT_NUMBER, EMAIL, NAME, PHONE, PIN, SSN, or ALL.

Length Constraints: Minimum length of 1. Maximum length of 300.

media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration.post_call_analytics_settings

The settings for a post-call analysis task in an analytics configuration.

Show child fields
media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration.post_call_analytics_settings.content_redaction_output

The content redaction output settings for a post-call analysis task.

media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration.post_call_analytics_settings.data_access_role_arn

The ARN of the role used by Amazon Web Services Transcribe to upload your post call analysis. For more information, see Post-call analytics with real-time transcriptions in the Amazon Transcribe Developer Guide.

media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration.post_call_analytics_settings.output_encryption_kms_key_id

The ID of the KMS (Key Management Service) key used to encrypt the output.

media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration.post_call_analytics_settings.output_location

The URL of the Amazon S3 bucket that contains the post-call data.

media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration.vocabulary_filter_method

Specifies how to apply a vocabulary filter to a transcript.

To replace words with ***, choose mask.

To delete words, choose remove.

To flag words without changing them, choose tag.

media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration.vocabulary_filter_name

Specifies the name of the custom vocabulary filter to use when processing a transcription. Note that vocabulary filter names are case sensitive.

If the language of the specified custom vocabulary filter doesn't match the language identified in your media, the vocabulary filter is not applied to your transcription.

For more information, see Using vocabulary filtering with unwanted words in the Amazon Transcribe Developer Guide.

Length Constraints: Minimum length of 1. Maximum length of 200.

media_insights_pipeline_configuration.elements[].amazon_transcribe_call_analytics_processor_configuration.vocabulary_name

Specifies the name of the custom vocabulary to use when processing a transcription. Note that vocabulary names are case sensitive.

If the language of the specified custom vocabulary doesn't match the language identified in your media, the custom vocabulary is not applied to your transcription.

For more information, see Custom vocabularies in the Amazon Transcribe Developer Guide.

Length Constraints: Minimum length of 1. Maximum length of 200.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration

The transcription processor configuration settings in a media insights pipeline configuration element.

Show child fields
media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.content_identification_type

Labels all personally identifiable information (PII) identified in your transcript.

Content identification is performed at the segment level; PII specified in PiiEntityTypes is flagged upon complete transcription of an audio segment.

You can’t set ContentIdentificationType and ContentRedactionType in the same request. If you set both, your request returns a BadRequestException.

For more information, see Redacting or identifying personally identifiable information in the Amazon Transcribe Developer Guide.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.content_redaction_type

Redacts all personally identifiable information (PII) identified in your transcript.

Content redaction is performed at the segment level; PII specified in PiiEntityTypes is redacted upon complete transcription of an audio segment.

You can’t set ContentRedactionType and ContentIdentificationType in the same request. If you set both, your request returns a BadRequestException.

For more information, see Redacting or identifying personally identifiable information in the Amazon Transcribe Developer Guide.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.enable_partial_results_stabilization

Enables partial result stabilization for your transcription. Partial result stabilization can reduce latency in your output, but may impact accuracy.

For more information, see Partial-result stabilization in the Amazon Transcribe Developer Guide.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.filter_partial_results

If true, TranscriptEvents with IsPartial: true are filtered out of the insights target.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.identify_language

Turns language identification on or off.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.identify_multiple_languages

Turns language identification on or off for multiple languages.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.language_code

The language code that represents the language spoken in your audio.

If you're unsure of the language spoken in your audio, consider using IdentifyLanguage to enable automatic language identification.

For a list of languages that real-time Call Analytics supports, see the Supported languages table in the Amazon Transcribe Developer Guide.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.language_model_name

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

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

For more information, see Custom language models in the Amazon Transcribe Developer Guide.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.language_options

The language options for the transcription, such as automatic language detection.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.partial_results_stability

The level of stability to use when you enable partial results stabilization (EnablePartialResultsStabilization).

Low stability provides the highest accuracy. High stability transcribes faster, but with slightly lower accuracy.

For more information, see Partial-result stabilization in the Amazon Transcribe Developer Guide.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.pii_entity_types

The types of personally identifiable information (PII) to redact from a transcript. You can include as many types as you'd like, or you can select ALL.

To include PiiEntityTypes in your Call Analytics request, you must also include ContentIdentificationType or ContentRedactionType, but you can't include both.

Values must be comma-separated and can include: ADDRESS, BANK_ACCOUNT_NUMBER, BANK_ROUTING, CREDIT_DEBIT_CVV, CREDIT_DEBIT_EXPIRY, CREDIT_DEBIT_NUMBER, EMAIL, NAME, PHONE, PIN, SSN, or ALL.

If you leave this parameter empty, the default behavior is equivalent to ALL.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.preferred_language

The preferred language for the transcription.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.show_speaker_label

Enables speaker partitioning (diarization) in your transcription output. Speaker partitioning labels the speech from individual speakers in your media file.

For more information, see Partitioning speakers (diarization) in the Amazon Transcribe Developer Guide.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.vocabulary_filter_method

The vocabulary filtering method used in your Call Analytics transcription.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.vocabulary_filter_name

The name of the custom vocabulary filter that you specified in your Call Analytics request.

Length Constraints: Minimum length of 1. Maximum length of 200.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.vocabulary_filter_names

The names of the custom vocabulary filter or filters using during transcription.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.vocabulary_name

The name of the custom vocabulary that you specified in your Call Analytics request.

Length Constraints: Minimum length of 1. Maximum length of 200.

media_insights_pipeline_configuration.elements[].amazon_transcribe_processor_configuration.vocabulary_names

The names of the custom vocabulary or vocabularies used during transcription.

media_insights_pipeline_configuration.elements[].kinesis_data_stream_sink_configuration

The configuration settings for the Kinesis Data Stream Sink in a media insights pipeline configuration element.

Show child fields
media_insights_pipeline_configuration.elements[].kinesis_data_stream_sink_configuration.insights_target

The ARN of the sink.

media_insights_pipeline_configuration.elements[].lambda_function_sink_configuration

The configuration settings for the Amazon Web Services Lambda sink in a media insights pipeline configuration element.

Show child fields
media_insights_pipeline_configuration.elements[].lambda_function_sink_configuration.insights_target

The ARN of the sink.

media_insights_pipeline_configuration.elements[].s3_recording_sink_configuration

The configuration settings for the Amazon S3 recording bucket in a media insights pipeline configuration element.

Show child fields
media_insights_pipeline_configuration.elements[].s3_recording_sink_configuration.destination

The default URI of the Amazon S3 bucket used as the recording sink.

media_insights_pipeline_configuration.elements[].s3_recording_sink_configuration.recording_file_format

The default file format for the media files sent to the Amazon S3 bucket.

media_insights_pipeline_configuration.elements[].sns_topic_sink_configuration

The configuration settings for an SNS topic sink in a media insights pipeline configuration element.

Show child fields
media_insights_pipeline_configuration.elements[].sns_topic_sink_configuration.insights_target

The ARN of the SNS sink.

media_insights_pipeline_configuration.elements[].sqs_queue_sink_configuration

The configuration settings for an SQS queue sink in a media insights pipeline configuration element.

Show child fields
media_insights_pipeline_configuration.elements[].sqs_queue_sink_configuration.insights_target

The ARN of the SQS sink.

media_insights_pipeline_configuration.elements[].type

The element type.

media_insights_pipeline_configuration.elements[].voice_analytics_processor_configuration

The voice analytics configuration settings in a media insights pipeline configuration element.

Show child fields
media_insights_pipeline_configuration.elements[].voice_analytics_processor_configuration.speaker_search_status

The status of the speaker search task.

media_insights_pipeline_configuration.elements[].voice_analytics_processor_configuration.voice_tone_analysis_status

The status of the voice tone analysis task.

media_insights_pipeline_configuration.elements[].voice_enhancement_sink_configuration

The configuration settings for voice enhancement sink in a media insights pipeline configuration element.

Show child fields
media_insights_pipeline_configuration.elements[].voice_enhancement_sink_configuration.disabled

Disables the VoiceEnhancementSinkConfiguration element.

media_insights_pipeline_configuration.media_insights_pipeline_configuration_arn

The ARN of the configuration.

media_insights_pipeline_configuration.media_insights_pipeline_configuration_id

The ID of the configuration.

media_insights_pipeline_configuration.media_insights_pipeline_configuration_name

The name of the configuration.

media_insights_pipeline_configuration.real_time_alert_configuration

Lists the rules that trigger a real-time alert.

Show child fields
media_insights_pipeline_configuration.real_time_alert_configuration.disabled

Turns off real-time alerts.

media_insights_pipeline_configuration.real_time_alert_configuration.rules[]
Show child fields
media_insights_pipeline_configuration.real_time_alert_configuration.rules[].issue_detection_configuration

Specifies the issue detection settings for a real-time alert rule.

Show child fields
media_insights_pipeline_configuration.real_time_alert_configuration.rules[].issue_detection_configuration.rule_name

The name of the issue detection rule.

media_insights_pipeline_configuration.real_time_alert_configuration.rules[].keyword_match_configuration

Specifies the settings for matching the keywords in a real-time alert rule.

Show child fields
media_insights_pipeline_configuration.real_time_alert_configuration.rules[].keyword_match_configuration.keywords[]
media_insights_pipeline_configuration.real_time_alert_configuration.rules[].keyword_match_configuration.negate

Matches keywords or phrases on their presence or absence. If set to TRUE, the rule matches when all the specified keywords or phrases are absent. Default: FALSE.

media_insights_pipeline_configuration.real_time_alert_configuration.rules[].keyword_match_configuration.rule_name

The name of the keyword match rule.

media_insights_pipeline_configuration.real_time_alert_configuration.rules[].sentiment_configuration

Specifies the settings for predicting sentiment in a real-time alert rule.

Show child fields
media_insights_pipeline_configuration.real_time_alert_configuration.rules[].sentiment_configuration.rule_name

The name of the rule in the sentiment configuration.

media_insights_pipeline_configuration.real_time_alert_configuration.rules[].sentiment_configuration.sentiment_type

The type of sentiment, POSITIVE, NEGATIVE, or NEUTRAL.

media_insights_pipeline_configuration.real_time_alert_configuration.rules[].sentiment_configuration.time_period

Specifies the analysis interval.

media_insights_pipeline_configuration.real_time_alert_configuration.rules[].type

The type of alert rule.

media_insights_pipeline_configuration.resource_access_role_arn

The ARN of the role used by the service to access Amazon Web Services resources.

media_insights_pipeline_configuration.updated_timestamp

The time at which the configuration was last updated.