turbot/aws_insights

Query: rds_db_cluster_multiple_az_status

Usage

powerpipe query aws_insights.query.rds_db_cluster_multiple_az_status

Steampipe Tables

SQL

with multiaz_enabled as (
select
distinct db_cluster_identifier as name
from
aws_rds_db_cluster
where
multi_az
group by name
),
multiaz_status as (
select
case
when c.name is not null then 'enabled'
else 'disabled' end as multiaz_stat
from
aws_rds_db_cluster as r
left join multiaz_enabled as c on r.db_cluster_identifier = c.name
)
select
multiaz_stat,
count(*)
from
multiaz_status
group by
multiaz_stat;

Dashboards

The query is used in the dashboards: