Query: vpc_not_in_use

with vpc_without_subnet as (
  select
    distinct vpc_id
  from
    aws_vpc
  where
    vpc_id not in (
      select
        vpc_id
      from
        aws_vpc_subnet
    )
)
select
  arn as resource,
  case
    when s.vpc_id is null then 'ok'
    else 'alarm'
  end as status,
  case
    when s.vpc_id is null then title || ' in use.'
    else title || ' not in use.'
  end as reason,
  region,
  account_id
from
  aws_vpc as v
  left join vpc_without_subnet as s on s.vpc_id = v.vpc_id;