steampipe plugin install awssteampipe plugin install aws

Table: aws_ecs_task

A task is the instantiation of a task definition within a cluster. After you have created a task definition for your application within Amazon ECS, you can specify the number of tasks that will run on your cluster.

Examples

Basic info

select
  cluster_name,
  desired_status,
  launch_type,
  task_arn
from
  aws_ecs_task;

List task attachment details

select
  cluster_name,
  task_arn,
  a ->> 'Id' as attachment_id,
  a ->> 'Status' as attachment_status,
  a ->> 'Type' as attachment_type,
  jsonb_pretty(a -> 'Details') as attachment_details
from
  aws_ecs_task,
  jsonb_array_elements(attachments) as a;

List task protection details

select
  cluster_name,
  task_arn,
  protection ->> 'ProtectionEnabled' as protection_enabled,
  protection ->> 'ExpirationDate' as protection_expiration_date
from
  aws_ecs_task;

Query examples

.inspect aws_ecs_task

AWS ECS Task

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.
attachments	jsonb	The Elastic Network Adapter associated with the task if the task uses the awsvpc network mode.
attributes	jsonb	The attributes of the task.
availability_zone	text	The availability zone of the task.
capacity_provider_name	text	The capacity provider associated with the task.
cluster_arn	text	The ARN of the cluster that hosts the task.
cluster_name	text	A user-generated string that you use to identify your cluster.
connectivity	text	The connectivity status of a task.
connectivity_at	timestamp with time zone	The Unix timestamp for when the task last went into CONNECTED status.
container_instance_arn	text	The ARN of the container instances that host the task.
containers	jsonb	The containers associated with the task.
cpu	bigint	The number of CPU units used by the task as expressed in a task definition.
created_at	timestamp with time zone	The Unix timestamp for when the task was created.
desired_status	text	The desired status of the task.
enable_execute_command	boolean	Whether or not execute command functionality is enabled for this task. If true, this enables execute command functionality on all containers in the task.
ephemeral_storage	jsonb	The ephemeral storage settings for the task.
execution_stopped_at	timestamp with time zone	The Unix timestamp for when the task execution stopped.
group	text	The name of the task group associated with the task.
health_status	text	The health status for the task, which is determined by the health of the essential containers in the task. If all essential containers in the task are reporting as HEALTHY, then the task status also reports as HEALTHY.
inference_accelerators	jsonb	The Elastic Inference accelerator associated with the task.
last_status	text	The last known status of the task.
launch_type	text	The infrastructure on which your task is running.
memory	bigint	The amount of memory (in MiB) used by the task as expressed in a task definition.
overrides	jsonb	One or more container overrides.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
platform_version	text	The platform version on which your task is running.
protection	jsonb	Protection status of task in an Amazon ECS service.
pull_started_at	timestamp with time zone	The Unix timestamp for when the container image pull began.
pull_stopped_at	timestamp with time zone	The Unix timestamp for when the container image pull completed.
region	text	The AWS Region in which the resource is located.
service_name	text	The name of the service.
started_at	timestamp with time zone	The Unix timestamp for when the task started.
started_by	text	The tag specified when a task is started.
stop_code	text	The stop code indicating why a task was stopped.
stopped_at	timestamp with time zone	The Unix timestamp for when the task was stopped.
stopped_reason	text	The reason that the task was stopped.
stopping_at	timestamp with time zone	The Unix timestamp for when the task stops.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags associated with task.
task_arn	text	The Amazon Resource Name (ARN) of the task.
task_definition_arn	text	The ARN of the task definition that creates the task.
version	bigint	The version counter for the task.

turbot/aws