Skip to content
AWS for Query.Farm

aws.connect.list_realtime_contact_analysis_segments_v2

Example SQL Queries

SELECT * FROM
aws.connect.list_realtime_contact_analysis_segments_v2
WHERE
"instance_id" = 'VALUE'
AND "contact_id" = 'VALUE'
AND "output_type" = 'VALUE'
AND "segment_types" = 'VALUE';

Description

Provides a list of analysis segments for a real-time analysis session.

Table Definition

Column NameColumn Data Type
contact_id Required Input Column

The identifier of the contact in this instance of Amazon Connect. 

VARCHAR
instance_id Required Input Column

The identifier of the Amazon Connect instance. You can find the instance ID in the Amazon Resource Name (ARN) of the instance.

VARCHAR
output_type Required Input Column

The Contact Lens output type to be returned.

VARCHAR
segment_types Required Input Column

Enum with segment types . Each value corresponds to a segment type returned in the segments list of the API. Each segment type has its own structure. Different channels may have different sets of supported segment types.

VARCHAR[]
Show child fields
segment_types[]
max_results Input Column

The maximum number of results to return per page.

BIGINT
next_token Input Column

If there are additional results, this is the token for the next set of 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
channel

The channel of the contact. Voice will not be returned. 

VARCHAR
segments

An analyzed transcript or category.

STRUCT(
    "transcript" STRUCT(
        "id" VARCHAR,
        "participant_id" VARCHAR,
        "participant_role" VARCHAR,
        "display_name" VARCHAR,
        "content" VARCHAR,
        "content_type" VARCHAR,
        "time" STRUCT(
            "absolute_time" TIMESTAMP_S
        ),
        "redaction" STRUCT(
            "character_offsets" STRUCT(
                "begin_offset_char" BIGINT,
                "end_offset_char" BIGINT
            )[]
        ),
        "sentiment" VARCHAR
    ),
    "categories" STRUCT(
        "matched_details" MAP(VARCHAR, STRUCT(
                "points_of_interest" STRUCT(
                    "transcript_items" STRUCT(
                        "id" VARCHAR,
                        "character_offsets" STRUCT(
                            "begin_offset_char" BIGINT,
                            "end_offset_char" BIGINT
                        )
                    )[]
                )[]
            ))
    ),
    "issues" STRUCT(
        "issues_detected" STRUCT(
            "transcript_items" STRUCT(
                "content" VARCHAR,
                "id" VARCHAR,
                "character_offsets" STRUCT(
                    "begin_offset_char" BIGINT,
                    "end_offset_char" BIGINT
                )
            )[]
        )[]
    ),
    "event" STRUCT(
        "id" VARCHAR,
        "participant_id" VARCHAR,
        "participant_role" VARCHAR,
        "display_name" VARCHAR,
        "event_type" VARCHAR,
        "time" STRUCT(
            "absolute_time" TIMESTAMP_S
        )
    ),
    "attachments" STRUCT(
        "id" VARCHAR,
        "participant_id" VARCHAR,
        "participant_role" VARCHAR,
        "display_name" VARCHAR,
        "attachments" STRUCT(
            "attachment_name" VARCHAR,
            "content_type" VARCHAR,
            "attachment_id" VARCHAR,
            "status" VARCHAR
        )[],
        "time" STRUCT(
            "absolute_time" TIMESTAMP_S
        )
    ),
    "post_contact_summary" STRUCT(
        "content" VARCHAR,
        "status" VARCHAR,
        "failure_code" VARCHAR
    )
)[]
Show child fields
segments[]
Show child fields
segments[].attachments

The analyzed attachments.

Show child fields
segments[].attachments.attachments[]
Show child fields
segments[].attachments.attachments[].attachment_id

A unique identifier for the attachment.

segments[].attachments.attachments[].attachment_name

A case-sensitive name of the attachment being uploaded. Can be redacted.

segments[].attachments.attachments[].content_type

Describes the MIME file type of the attachment. For a list of supported file types, see Feature specifications in the Amazon Connect Administrator Guide.

segments[].attachments.attachments[].status

Status of the attachment.

segments[].attachments.display_name

The display name of the participant. Can be redacted.

segments[].attachments.id

The identifier of the segment.

segments[].attachments.participant_id

The identifier of the participant.

segments[].attachments.participant_role

The role of the participant. For example, is it a customer, agent, or system.

segments[].attachments.time

Field describing the time of the event. It can have different representations of time.

Show child fields
segments[].attachments.time.absolute_time

Time represented in ISO 8601 format: yyyy-MM-ddThh:mm:ss.SSSZ. For example, 2019-11-08T02:41:28.172Z.

segments[].categories

The matched category rules.

Show child fields
segments[].categories.matched_details

Map between the name of the matched rule and RealTimeContactAnalysisCategoryDetails.

segments[].event

Segment type describing a contact event.

Show child fields
segments[].event.display_name

The display name of the participant. Can be redacted.

segments[].event.event_type

Type of the event. For example, application/vnd.amazonaws.connect.event.participant.left.

segments[].event.id

The identifier of the contact event.

segments[].event.participant_id

The identifier of the participant.

segments[].event.participant_role

The role of the participant. For example, is it a customer, agent, or system.

segments[].event.time

Field describing the time of the event. It can have different representations of time.

Show child fields
segments[].event.time.absolute_time

Time represented in ISO 8601 format: yyyy-MM-ddThh:mm:ss.SSSZ. For example, 2019-11-08T02:41:28.172Z.

segments[].issues

Segment type containing a list of detected issues.

Show child fields
segments[].issues.issues_detected[]
Show child fields
segments[].issues.issues_detected[].transcript_items[]
Show child fields
segments[].issues.issues_detected[].transcript_items[].character_offsets

Begin and end offsets for a part of text.

Show child fields
segments[].issues.issues_detected[].transcript_items[].character_offsets.begin_offset_char

The beginning of the character interval.

segments[].issues.issues_detected[].transcript_items[].character_offsets.end_offset_char

The end of the character interval.

segments[].issues.issues_detected[].transcript_items[].content

Part of the transcript content that contains identified issue. Can be redacted

segments[].issues.issues_detected[].transcript_items[].id

Transcript identifier. Matches the identifier from one of the TranscriptSegments.

segments[].post_contact_summary

Information about the post-contact summary.

Show child fields
segments[].post_contact_summary.content

The content of the summary.

segments[].post_contact_summary.failure_code

If the summary failed to be generated, one of the following failure codes occurs:

  • QUOTA_EXCEEDED: The number of concurrent analytics jobs reached your service quota.

  • INSUFFICIENT_CONVERSATION_CONTENT: The conversation needs to have at least one turn from both the participants in order to generate the summary.

  • FAILED_SAFETY_GUIDELINES: The generated summary cannot be provided because it failed to meet system safety guidelines.

  • INVALID_ANALYSIS_CONFIGURATION: This code occurs when, for example, you're using a language that isn't supported by generative AI-powered post-contact summaries.

  • INTERNAL_ERROR: Internal system error.

segments[].post_contact_summary.status

Whether the summary was successfully COMPLETED or FAILED to be generated.

segments[].transcript

The analyzed transcript segment.

Show child fields
segments[].transcript.content

The content of the transcript. Can be redacted.

segments[].transcript.content_type

The type of content of the item. For example, text/plain.

segments[].transcript.display_name

The display name of the participant.

segments[].transcript.id

The identifier of the transcript.

segments[].transcript.participant_id

The identifier of the participant.

segments[].transcript.participant_role

The role of the participant. For example, is it a customer, agent, or system.

segments[].transcript.redaction

Object describing redaction that was applied to the transcript. If transcript has the field it means part of the transcript was redacted.

Show child fields
segments[].transcript.redaction.character_offsets[]
Show child fields
segments[].transcript.redaction.character_offsets[].begin_offset_char

The beginning of the character interval.

segments[].transcript.redaction.character_offsets[].end_offset_char

The end of the character interval.

segments[].transcript.sentiment

The sentiment detected for this piece of transcript.

segments[].transcript.time

Field describing the time of the event. It can have different representations of time.

Show child fields
segments[].transcript.time.absolute_time

Time represented in ISO 8601 format: yyyy-MM-ddThh:mm:ss.SSSZ. For example, 2019-11-08T02:41:28.172Z.

status

Status of real-time contact analysis.

VARCHAR