Control: RDS DB instances should be deployed in a VPC
Description
This control checks whether RDS DB instances are deployed in a VPC.
Usage
Run the control in your terminal:
powerpipe control run aws_perimeter.control.rds_db_instance_in_vpcSnapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_perimeter.control.rds_db_instance_in_vpc --shareSteampipe Tables
SQL
select  arn as resource,  case    when vpc_id is null then 'alarm'    else 'ok'  end as status,  case    when vpc_id is null then title || ' not in VPC.'    else title || ' in VPC ' || vpc_id || '.'  end as reason    , region, account_idfrom  aws_rds_db_instance;