Skip to content
AWS for Query.Farm

aws.route53.get_health_check_last_failure_reason

Example SQL Queries

SELECT * FROM
aws.route53.get_health_check_last_failure_reason
WHERE
"health_check_id" = 'VALUE';

Description

Gets the reason that a specified health check failed most recently.

Table Definition

Column NameColumn Data Type
health_check_id Required Input Column

The ID for the health check for which you want the last failure reason. When you created the health check, CreateHealthCheck returned the ID in the response, in the HealthCheckId element.

If you want to get the last failure reason for a calculated health check, you must use the Amazon Route 53 console or the CloudWatch console. You can't use GetHealthCheckLastFailureReason for a calculated health check.

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.

health_check_observations

A list that contains one Observation element for each Amazon Route 53 health checker that is reporting a last failure reason. 

STRUCT(
    "region" VARCHAR,
    "ip_address" VARCHAR,
    "status_report" STRUCT(
        "status" VARCHAR,
        "checked_time" TIMESTAMP_S
    )
)[]
Show child fields
health_check_observations[]
Show child fields
health_check_observations[].ip_address

The IP address of the Amazon Route 53 health checker that provided the failure reason in StatusReport.

health_check_observations[].region

The region of the Amazon Route 53 health checker that provided the status in StatusReport.

health_check_observations[].status_report

A complex type that contains the last failure reason as reported by one Amazon Route 53 health checker and the time of the failed health check.

Show child fields
health_check_observations[].status_report.checked_time

The date and time that the health checker performed the health check in ISO 8601 format and Coordinated Universal Time (UTC). For example, the value 2017-03-27T17:48:16.751Z represents March 27, 2017 at 17:48:16.751 UTC.

health_check_observations[].status_report.status

A description of the status of the health check endpoint as reported by one of the Amazon Route 53 health checkers.