Skip to content
AWS for Query.Farm

aws.xray.get_insight_events

Example SQL Queries

SELECT * FROM
aws.xray.get_insight_events
WHERE
"insight_id" = 'VALUE';

Description

X-Ray reevaluates insights periodically until they're resolved, and records each intermediate state as an event. You can review an insight's events in the Impact Timeline on the Inspect page in the X-Ray console.

Table Definition

Column NameColumn Data Type
insight_id Required Input Column

The insight's unique identifier. Use the GetInsightSummaries action to retrieve an InsightId.

VARCHAR
max_results Input Column

Used to retrieve at most the specified value of events.

BIGINT
next_token Input Column

Use this token to retrieve the next page of insight events.

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
insight_events

A detailed description of the event. This includes the time of the event, client and root cause impact statistics, and the top anomalous service at the time of the event.

STRUCT(
    "summary" VARCHAR,
    "event_time" TIMESTAMP_S,
    "client_request_impact_statistics" STRUCT(
        "fault_count" BIGINT,
        "ok_count" BIGINT,
        "total_count" BIGINT
    ),
    "root_cause_service_request_impact_statistics" STRUCT(
        "fault_count" BIGINT,
        "ok_count" BIGINT,
        "total_count" BIGINT
    ),
    "top_anomalous_services" STRUCT(
        "service_id" STRUCT(
            "name" VARCHAR,
            "names" VARCHAR[],
            "account_id" VARCHAR,
            "type" VARCHAR
        )
    )[]
)[]
Show child fields
insight_events[]
Show child fields
insight_events[].client_request_impact_statistics

The impact statistics of the client side service. This includes the number of requests to the client service and whether the requests were faults or okay.

Show child fields
insight_events[].client_request_impact_statistics.fault_count

The number of requests that have resulted in a fault,

insight_events[].client_request_impact_statistics.ok_count

The number of successful requests.

insight_events[].client_request_impact_statistics.total_count

The total number of requests to the service.

insight_events[].event_time

The time, in Unix seconds, at which the event was recorded.

insight_events[].root_cause_service_request_impact_statistics

The impact statistics of the root cause service. This includes the number of requests to the client service and whether the requests were faults or okay.

Show child fields
insight_events[].root_cause_service_request_impact_statistics.fault_count

The number of requests that have resulted in a fault,

insight_events[].root_cause_service_request_impact_statistics.ok_count

The number of successful requests.

insight_events[].root_cause_service_request_impact_statistics.total_count

The total number of requests to the service.

insight_events[].summary

A brief description of the event.

insight_events[].top_anomalous_services[]
Show child fields
insight_events[].top_anomalous_services[].service_id

Show child fields
insight_events[].top_anomalous_services[].service_id.account_id

insight_events[].top_anomalous_services[].service_id.name

insight_events[].top_anomalous_services[].service_id.names[]
insight_events[].top_anomalous_services[].service_id.type