steampipe plugin install awssteampipe plugin install aws

Table: aws_eks_fargate_profile

The Fargate profile allows an administrator to declare which pods run on Fargate. Each profile can have up to five selectors that contain a namespace and optional labels. You must define a namespace for every selector. The label field consists of multiple optional key-value pairs. Pods that match a selector (by matching a namespace for the selector and all of the labels specified in the selector) are scheduled on Fargate.

Examples

Basic info

select
  fargate_profile_name,
  fargate_profile_arn,
  cluster_name,
  created_at,
  status,
  tags
from
  aws_eks_fargate_profile;

List fargate profiles which are inactive

select
  fargate_profile_name,
  fargate_profile_arn,
  cluster_name,
  created_at,
  status
from
  aws_eks_fargate_profile
where
  status <> 'ACTIVE';

Get the subnet configuration for each fargate profile

select
  f.fargate_profile_name,
  f.cluster_name,
  f.status as fargate_profile_status,
  s.availability_zone,
  s.available_ip_address_count,
  s.cidr_block,
  s.vpc_id
from
  aws_eks_fargate_profile as f,
  aws_vpc_subnet as s,
  jsonb_array_elements(f.subnets) as subnet_id
where
  s.subnet_id = subnet_id;

List fargate profiles for clusters not running Kubernetes version greater than 1.19

select
  c.name as cluster_name,
  c.arn as cluster_arn,
  c.version as cluster_version,
  f.fargate_profile_name as fargate_profile_name,
  f.fargate_profile_arn as fargate_profile_arn,
  f.created_at as created_at,
  f.pod_execution_role_arn as pod_execution_role_arn,
  f.status as fargate_profile_status
from
  aws_eks_fargate_profile as f,
  aws_eks_cluster as c
where
  c.version :: float > 1.19
  and f.cluster_name = c.name;

Query examples

eks_fargate_profiles_for_eks_cluster

.inspect aws_eks_fargate_profile

AWS Elastic Kubernetes Service Fargate Profile

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.
cluster_name	text	The name of the Amazon EKS cluster that the Fargate profile belongs to.
created_at	timestamp with time zone	The Unix epoch timestamp in seconds for when the Fargate profile was created.
fargate_profile_arn	text	The full Amazon Resource Name (ARN) of the Fargate profile.
fargate_profile_name	text	The name of the Fargate profile.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
pod_execution_role_arn	text	The Amazon Resource Name (ARN) of the pod execution role to use for pods that match the selectors in the Fargate profile.
region	text	The AWS Region in which the resource is located.
selectors	jsonb	The selectors to match for pods to use this Fargate profile.
status	text	The current status of the Fargate profile.
subnets	jsonb	The subnets used by the Fargate profile.
tags	jsonb	A list of tags assigned to the Fargate profile.
title	text	Title of the resource.

turbot/aws