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;

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