Skip to content
AWS for Query.Farm

aws.events.describe_replay

Example SQL Queries

SELECT * FROM
aws.events.describe_replay
WHERE
"replay_name" = 'VALUE';

Description

Retrieves details about a replay. Use DescribeReplay to determine the progress of a running replay. A replay processes events to replay based on the time in the event, and replays them using 1 minute intervals. If you use StartReplay and specify an EventStartTime and an EventEndTime that covers a 20 minute time range, the events are replayed from the first minute of that 20 minute range first. Then the events from the second minute are replayed. You can use DescribeReplay to determine the progress of a replay. The value returned for EventLastReplayedTime indicates the time within the specified time range associated with the last event replayed.

Table Definition

Column NameColumn Data Type
replay_name Required Input Column

The name of the replay.

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
description

The description of the replay.

VARCHAR
destination

A ReplayDestination object that contains details about the replay.

STRUCT(
    "arn" VARCHAR,
    "filter_arns" VARCHAR[]
)
Show child fields
destination.arn

The ARN of the event bus to replay event to. You can replay events only to the event bus specified to create the archive.

destination.filter_arns[]
event_end_time

The time stamp for the last event that was replayed from the archive.

TIMESTAMP_S
event_last_replayed_time

The time that the event was last replayed.

TIMESTAMP_S
event_source_arn

The ARN of the archive events were replayed from.

VARCHAR
event_start_time

The time stamp of the first event that was last replayed from the archive.

TIMESTAMP_S
replay_arn

The ARN of the replay.

VARCHAR
replay_end_time

A time stamp for the time that the replay stopped.

TIMESTAMP_S
replay_start_time

A time stamp for the time that the replay started.

TIMESTAMP_S
state

The current state of the replay.

VARCHAR
state_reason

The reason that the replay is in the current state.

VARCHAR