turbot/aws_insights

Query: rds_db_instance_public_status

Usage

powerpipe query aws_insights.query.rds_db_instance_public_status

Steampipe Tables

SQL

with db_instances as (
select
case
when publicly_accessible is null
or (not publicly_accessible) then 'private'
else 'public'
end as visibility
from
aws_rds_db_instance
)
select
visibility,
count(*)
from
db_instances
group by
visibility;

Dashboards

The query is used in the dashboards: