steampipe plugin install aws

Table: aws_globalaccelerator_endpoint_group - Query AWS Global Accelerator Endpoint Groups using SQL

The AWS Global Accelerator Endpoint Group is a component of AWS Global Accelerator that improves the availability and performance of applications by automatically routing traffic to optimal endpoints within a global network. The endpoint group includes one or more endpoints, such as Network Load Balancers, Application Load Balancers, EC2 Instances, or Elastic IP addresses. It is designed to provide consistent, high-quality network performance for AWS services across the globe.

Table Usage Guide

The aws_globalaccelerator_endpoint_group table in Steampipe provides you with information about endpoint groups within AWS Global Accelerator. This table enables you, as a DevOps engineer, to query group-specific details, including the health state, traffic dial percentage, and associated endpoints. You can utilize this table to gather insights on endpoint groups, such as endpoint configurations, health check settings, and more. The schema outlines the various attributes of the endpoint group for you, including the endpoint group ARN, listener ARN, traffic dial percentage, and health check configurations.

Examples

Basic info

This query allows you to assess the configuration details of your AWS Global Accelerator's endpoint groups, such as their regional distribution, health check parameters, and traffic management settings. This can be useful for optimizing your network performance and ensuring robust health monitoring.

select
title,
endpoint_descriptions,
endpoint_group_region,
traffic_dial_percentage,
port_overrides,
health_check_interval_seconds,
health_check_path,
health_check_port,
health_check_protocol,
threshold_count
from
aws_globalaccelerator_endpoint_group;
select
title,
endpoint_descriptions,
endpoint_group_region,
traffic_dial_percentage,
port_overrides,
health_check_interval_seconds,
health_check_path,
health_check_port,
health_check_protocol,
threshold_count
from
aws_globalaccelerator_endpoint_group;

List endpoint groups for a specific listener

Identify the specific endpoint groups associated with a certain listener in the AWS Global Accelerator service. This query aids in understanding the configuration and health check parameters of these endpoint groups, which is useful for managing network traffic and ensuring optimal performance.

select
title,
endpoint_descriptions,
endpoint_group_region,
traffic_dial_percentage,
port_overrides,
health_check_interval_seconds,
health_check_path,
health_check_port,
health_check_protocol,
threshold_count
from
aws_globalaccelerator_endpoint_group
where
listener_arn = 'arn:aws:globalaccelerator::012345678901:accelerator/1234abcd-abcd-1234-abcd-1234abcdefgh/listener/abcdef1234';
select
title,
endpoint_descriptions,
endpoint_group_region,
traffic_dial_percentage,
port_overrides,
health_check_interval_seconds,
health_check_path,
health_check_port,
health_check_protocol,
threshold_count
from
aws_globalaccelerator_endpoint_group
where
listener_arn = 'arn:aws:globalaccelerator::012345678901:accelerator/1234abcd-abcd-1234-abcd-1234abcdefgh/listener/abcdef1234';

Get basic info for all accelerators, listeners, and endpoint groups

Explore the configuration details of all accelerators, listeners, and endpoint groups to gain insights into their performance and health check settings. This is useful for assessing the efficiency and reliability of your network traffic routing and identifying areas for potential improvements.

select
a.name as accelerator_name,
l.client_affinity as listener_client_affinity,
l.port_ranges as listener_port_ranges,
l.protocol as listener_protocol,
eg.endpoint_descriptions,
eg.endpoint_group_region,
eg.traffic_dial_percentage,
eg.port_overrides,
eg.health_check_interval_seconds,
eg.health_check_path,
eg.health_check_port,
eg.health_check_protocol,
eg.threshold_count
from
aws_globalaccelerator_accelerator a,
aws_globalaccelerator_listener l,
aws_globalaccelerator_endpoint_group eg
where
eg.listener_arn = l.arn
and l.accelerator_arn = a.arn;
select
a.name as accelerator_name,
l.client_affinity as listener_client_affinity,
l.port_ranges as listener_port_ranges,
l.protocol as listener_protocol,
eg.endpoint_descriptions,
eg.endpoint_group_region,
eg.traffic_dial_percentage,
eg.port_overrides,
eg.health_check_interval_seconds,
eg.health_check_path,
eg.health_check_port,
eg.health_check_protocol,
eg.threshold_count
from
aws_globalaccelerator_accelerator a,
aws_globalaccelerator_listener l,
aws_globalaccelerator_endpoint_group eg
where
eg.listener_arn = l.arn
and l.accelerator_arn = a.arn;

Schema for aws_globalaccelerator_endpoint_group

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextThe AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
arntext=The Amazon Resource Name (ARN) of the endpoint group.
endpoint_descriptionsjsonbThe list of endpoint objects.
endpoint_group_regiontextThe AWS Region where the endpoint group is located.
health_check_interval_secondsbigintThe time—10 seconds or 30 seconds—between health checks for each endpoint.
health_check_pathtextIf the protocol is HTTP/S, then this value provides the ping path that Global Accelerator uses for the destination on the endpoints for health checks.
health_check_portbigintThe port that Global Accelerator uses to perform health checks on endpoints that are part of this endpoint group.
health_check_protocoltextThe protocol that Global Accelerator uses to perform health checks on endpoints that are part of this endpoint group.
listener_arntext=The Amazon Resource Name (ARN) of parent listener.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
port_overridesjsonbOverrides for destination ports used to route traffic to an endpoint.
regiontextThe AWS Region in which the resource is located.
threshold_countbigintThe number of consecutive health checks required to set the state of a healthy endpoint to unhealthy, or to set an unhealthy endpoint to healthy.
titletextTitle of the resource.
traffic_dial_percentagedouble precisionThe percentage of traffic to send to an AWS Region.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_globalaccelerator_endpoint_group