turbot/aws_insights

Query: rds_db_instance_multiple_az_status

Usage

powerpipe query aws_insights.query.rds_db_instance_multiple_az_status

Steampipe Tables

SQL

with db_instances as (
select
case
when multi_az then 'enabled'
else 'disabled'
end as visibility
from
aws_rds_db_instance
where
engine not ilike any (array [ '%aurora-mysql%', '%aurora-postgres%' ])
)
select
visibility,
count(*)
from
db_instances
group by
visibility;

Dashboards

The query is used in the dashboards: