Query: ecs_tasks_for_ecs_service

select
  t.task_arn as task_arn
from
  aws_ecs_task as t,
  aws_ecs_service as s
where
  s.arn = $1
  and s.account_id = split_part($1, ':', 5)
  and s.region = split_part($1, ':', 4)
  and t.service_name = s.service_name
  and t.region = s.region;