turbot/aws_insights

Query: ecs_clusters_for_ecs_service

Usage

powerpipe query aws_insights.query.ecs_clusters_for_ecs_service

SQL

select
c.cluster_arn as cluster_arn
from
aws_ecs_service as s
left join aws_ecs_cluster as c on s.cluster_arn = c.cluster_arn and s.arn = $1
where
c.cluster_arn is not null
and s.account_id = split_part($1, ':', 5)
and s.region = split_part($1, ':', 4);