Query: ElastiCache clusters should not use public_subnet

Description

This control checks if ElastiCache clusters are configured with public subnet as there is a risk of exposing sensitive data.

Query

Tables used in this query:

• aws_elasticache_cluster
• aws_elasticache_subnet_group
• aws_vpc_route_table
• aws_vpc_subnet

Controls using this query:

• ElastiCache clusters should not use public_subnet

SQL