aws.application_insights.describe_observation

Example SQL Queries

SELECT * FROM
aws.application_insights.describe_observation
WHERE
"observation_id" = 'VALUE';

Description

Describes an anomaly or error with the application.

Table Definition

Column Name	Column Data Type
`observation_id` Required Input Column The ID of the observation.	VARCHAR
`account_id` Input Column The AWS account ID for the resource group owner.	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.
`observation` Information about the observation.	STRUCT( "id" VARCHAR, "start_time" TIMESTAMP_S, "end_time" TIMESTAMP_S, "source_type" VARCHAR, "source_arn" VARCHAR, "log_group" VARCHAR, "line_time" TIMESTAMP_S, "log_text" VARCHAR, "log_filter" VARCHAR, "metric_namespace" VARCHAR, "metric_name" VARCHAR, "unit" VARCHAR, "value" DOUBLE, "cloud_watch_event_id" VARCHAR, "cloud_watch_event_source" VARCHAR, "cloud_watch_event_detail_type" VARCHAR, "health_event_arn" VARCHAR, "health_service" VARCHAR, "health_event_type_code" VARCHAR, "health_event_type_category" VARCHAR, "health_event_description" VARCHAR, "code_deploy_deployment_id" VARCHAR, "code_deploy_deployment_group" VARCHAR, "code_deploy_state" VARCHAR, "code_deploy_application" VARCHAR, "code_deploy_instance_group_id" VARCHAR, "ec2_state" VARCHAR, "rds_event_categories" VARCHAR, "rds_event_message" VARCHAR, "s3_event_name" VARCHAR, "states_execution_arn" VARCHAR, "states_arn" VARCHAR, "states_status" VARCHAR, "states_input" VARCHAR, "ebs_event" VARCHAR, "ebs_result" VARCHAR, "ebs_cause" VARCHAR, "ebs_request_id" VARCHAR, "x_ray_fault_percent" BIGINT, "x_ray_throttle_percent" BIGINT, "x_ray_error_percent" BIGINT, "x_ray_request_count" BIGINT, "x_ray_request_average_latency" BIGINT, "x_ray_node_name" VARCHAR, "x_ray_node_type" VARCHAR )
Show child fields `observation.cloud_watch_event_detail_type` The detail type of the CloudWatch Event-based observation, for example, `EC2 Instance State-change Notification`. `observation.cloud_watch_event_id` The ID of the CloudWatch Event-based observation related to the detected problem. `observation.cloud_watch_event_source` The source of the CloudWatch Event. `observation.code_deploy_application` The CodeDeploy application to which the deployment belongs. `observation.code_deploy_deployment_group` The deployment group to which the CodeDeploy deployment belongs. `observation.code_deploy_deployment_id` The deployment ID of the CodeDeploy-based observation related to the detected problem. `observation.code_deploy_instance_group_id` The instance group to which the CodeDeploy instance belongs. `observation.code_deploy_state` The status of the CodeDeploy deployment, for example `SUCCESS` or `FAILURE`. `observation.ebs_cause` The cause of an EBS CloudWatch event. `observation.ebs_event` The type of EBS CloudWatch event, such as `createVolume`, `deleteVolume` or `attachVolume`. `observation.ebs_request_id` The request ID of an EBS CloudWatch event. `observation.ebs_result` The result of an EBS CloudWatch event, such as `failed` or `succeeded`. `observation.ec2_state` The state of the instance, such as `STOPPING` or `TERMINATING`. `observation.end_time` The time when the observation ended, in epoch seconds. `observation.health_event_arn` The Amazon Resource Name (ARN) of the AWS Health Event-based observation. `observation.health_event_description` The description of the AWS Health event provided by the service, such as Amazon EC2. `observation.health_event_type_category` The category of the AWS Health event, such as `issue`. `observation.health_event_type_code` The type of the AWS Health event, for example, `AWS_EC2_POWER_CONNECTIVITY_ISSUE`. `observation.health_service` The service to which the AWS Health Event belongs, such as EC2. `observation.id` The ID of the observation type. `observation.line_time` The timestamp in the CloudWatch Logs that specifies when the matched line occurred. `observation.log_filter` The log filter of the observation. `observation.log_group` The log group name. `observation.log_text` The log text of the observation. `observation.metric_name` The name of the observation metric. `observation.metric_namespace` The namespace of the observation metric. `observation.rds_event_categories` The category of an RDS event. `observation.rds_event_message` The message of an RDS event. `observation.s3_event_name` The name of the S3 CloudWatch Event-based observation. `observation.source_arn` The source resource ARN of the observation. `observation.source_type` The source type of the observation. `observation.start_time` The time when the observation was first detected, in epoch seconds. `observation.states_arn` The Amazon Resource Name (ARN) of the step function-based observation. `observation.states_execution_arn` The Amazon Resource Name (ARN) of the step function execution-based observation. `observation.states_input` The input to the step function-based observation. `observation.states_status` The status of the step function-related observation. `observation.unit` The unit of the source observation metric. `observation.value` The value of the source observation metric. `observation.x_ray_error_percent` The X-Ray request error percentage for this node. `observation.x_ray_fault_percent` The X-Ray request fault percentage for this node. `observation.x_ray_node_name` The name of the X-Ray node. `observation.x_ray_node_type` The type of the X-Ray node. `observation.x_ray_request_average_latency` The X-Ray node request average latency for this node. `observation.x_ray_request_count` The X-Ray request count for this node. `observation.x_ray_throttle_percent` The X-Ray request throttle percentage for this node.