steampipe plugin install awssteampipe plugin install aws

Table: aws_ec2_target_group

Target group is used to route requests to one or more registered targets for a load balancer.

Examples

Basic target group info

select
  target_group_name,
  target_type,
  load_balancer_arns,
  vpc_id
from
  aws_ec2_target_group;

Health check info of target groups

select
  health_check_enabled,
  protocol,
  matcher_http_code,
  healthy_threshold_count,
  unhealthy_threshold_count,
  health_check_enabled,
  health_check_interval_seconds,
  health_check_path,
  health_check_port,
  health_check_protocol,
  health_check_timeout_seconds
from
  aws_ec2_target_group;

Registered target for each target group

select
  target_group_name,
  target_type,
  target -> 'Target' ->> 'AvailabilityZone' as availability_zone,
  target -> 'Target' ->> 'Id' as id,
  target -> 'Target' ->> 'Port' as port
from
  aws_ec2_target_group
  cross join jsonb_array_elements(target_health_descriptions) as target;

Health status of registered targets

select
  target_group_name,
  target_type,
  target -> 'TargetHealth' ->> 'Description' as description,
  target -> 'TargetHealth' ->> 'Reason' reason,
  target -> 'TargetHealth' ->> 'State' as state
from
  aws_ec2_target_group
  cross join jsonb_array_elements(target_health_descriptions) as target;

Query examples

Control examples

.inspect aws_ec2_target_group

AWS EC2 Target Group

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
health_check_enabled	boolean	Indicates whether health checks are enabled.
health_check_interval_seconds	bigint	The approximate amount of time, in seconds, between health checks of an individual target.
health_check_path	text	The destination for health checks on the target.
health_check_port	text	The port to use to connect with the target.
health_check_protocol	text	The protocol to use to connect with the target. The GENEVE, TLS, UDP, and TCP_UDP protocols are not supported for health checks.
health_check_timeout_seconds	bigint	The amount of time, in seconds, during which no response means a failed health check.
healthy_threshold_count	bigint	The number of consecutive health checks successes required before considering an unhealthy target healthy.
load_balancer_arns	jsonb	The Amazon Resource Names (ARN) of the load balancers that route traffic to this target group.
matcher_grpc_code	text	The gRPC codes to use when checking for a successful response from a target.
matcher_http_code	text	The HTTP codes to use when checking for a successful response from a target.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
port	bigint	The port on which the targets are listening. Not used if the target is a Lambda function.
protocol	text	The protocol to use for routing traffic to the target.
region	text	The AWS Region in which the resource is located.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags associated with target group.
target_group_arn	text	The Amazon Resource Name (ARN) of the target group.
target_group_name	text	The name of the target group.
target_health_descriptions	jsonb	Contains information about the health of the target.
target_type	text	The type of target that is specified when registering targets with this target group. The possible values are instance (register targets by instance ID), ip (register targets by IP address), or lambda (register a single Lambda function as a target).
title	text	Title of the resource.
unhealthy_threshold_count	bigint	The number of consecutive health checks successes required before considering an unhealthy target healthy.
vpc_id	text	The ID of the VPC for the target.

turbot/aws

Table: aws_ec2_target_group

Examples

Basic target group info

Health check info of target groups

Registered target for each target group

Health status of registered targets

Query examples

Control examples

.inspect aws_ec2_target_group

Steampipe

Resources

Community