Query: vpc_security_groups_for_ec2_instance

select
  sg ->> 'GroupId' as security_group_id
from
  aws_ec2_instance as i,
  jsonb_array_elements(security_groups) as sg
where
  i.account_id = split_part($1, ':', 5)
  and i.region = split_part($1, ':', 4)
  and arn = $1;