Control: ECS service should use autoscaling policy

powerpipe control run aws_thrifty.control.ecs_service_without_autoscaling

powerpipe login
powerpipe control run aws_thrifty.control.ecs_service_without_autoscaling --share

with service_with_autoscaling as (
  select
    distinct split_part(t.resource_id, '/', 2) as cluster_name,
    split_part(t.resource_id, '/', 3) as service_name
  from
    aws_appautoscaling_target as t
  where
    t.service_namespace = 'ecs'
)
select
  s.arn as resource,
  case
    when s.launch_type != 'FARGATE' then 'skip'
    when a.service_name is null then 'alarm'
    else 'ok'
  end as status,
  case
    when s.launch_type != 'FARGATE' then s.title || ' task not running on FARGATE.'
    when a.service_name is null then s.title || ' autoscaling disabled.'
    else s.title || ' autoscaling enabled.'
  end as reason
  
  , s.region, s.account_id
from
  aws_ecs_service as s
  left join service_with_autoscaling as a on s.service_name = a.service_name and a.cluster_name = split_part(s.cluster_arn, '/', 2);