steampipe plugin install aws

Table: aws_eks_addon - Query AWS EKS Add-Ons using SQL

The AWS EKS Add-Ons are additional software components that enhance the functionality of your Amazon Elastic Kubernetes Service (EKS) clusters. They provide a way to deploy and manage Kubernetes applications, improve cluster security, and simplify cluster management. Using AWS EKS Add-Ons, you can automate time-consuming tasks such as patching, updating, and scaling.

Table Usage Guide

The aws_eks_addon table in Steampipe provides you with information about add-ons associated with each Amazon EKS cluster. This table allows you, as a DevOps engineer, to query add-on-specific details, including add-on versions, status, and associated metadata. You can utilize this table to gather insights on add-ons, such as the current version of each add-on, the health of add-ons, and more. The schema outlines the various attributes of the EKS add-on for you, including the add-on name, add-on version, service account role ARN, and associated tags.

Examples

Basic info

Explore the status of various add-ons within your AWS EKS clusters to understand their versions and associated roles. This can be beneficial for assessing the current configuration and ensuring the optimal functionality of your clusters.

select
addon_name,
arn,
addon_version,
cluster_name,
status,
service_account_role_arn
from
aws_eks_addon;
select
addon_name,
arn,
addon_version,
cluster_name,
status,
service_account_role_arn
from
aws_eks_addon;

List add-ons that are not active

Identify instances where certain add-ons in the AWS EKS service are not active. This can help in monitoring and managing resources effectively by pinpointing inactive add-ons that may need attention or removal.

select
addon_name,
arn,
cluster_name,
status
from
aws_eks_addon
where
status <> 'ACTIVE';
select
addon_name,
arn,
cluster_name,
status
from
aws_eks_addon
where
status != 'ACTIVE';

Get count of add-ons by cluster

Determine the total number of add-ons per cluster within your AWS EKS environment to better manage resources and understand utilization.

select
cluster_name,
count(addon_name) as addon_count
from
aws_eks_addon
group by
cluster_name;
select
cluster_name,
count(addon_name) as addon_count
from
aws_eks_addon
group by
cluster_name;

Schema for aws_eks_addon

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextThe AWS Account ID in which the resource is located.
addon_nametext=The name of the add-on.
addon_versiontextThe version of the add-on.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
arntextThe Amazon Resource Name (ARN) of the add-on.
cluster_nametext=The name of the cluster.
created_attimestamp with time zoneThe date and time that the add-on was created.
health_issuesjsonbAn object that represents the add-on's health issues.
modified_attimestamp with time zoneThe date and time that the add-on was last modified.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
service_account_role_arntextThe Amazon Resource Name (ARN) of the IAM role that is bound to the Kubernetes service account used by the add-on.
statustextThe status of the add-on.
tagsjsonbThe metadata that you apply to the cluster to assist with categorization and organization.
titletextTitle of the resource.

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_eks_addon