Query: vpc_security_groups_for_ecs_service

select
  sg.group_id as group_id
from
  aws_ecs_service as e,
  jsonb_array_elements_text(
    e.network_configuration -> 'AwsvpcConfiguration' -> 'SecurityGroups'
  ) as s
  left join aws_vpc_security_group as sg on sg.group_id = s
where
  e.arn = $1
  and e.network_configuration is not null;