turbot/aws_insights

Query: rds_db_cluster_snapshot_iam_authentication_enabled

Usage

powerpipe query aws_insights.query.rds_db_cluster_snapshot_iam_authentication_enabled

SQL

with iam_authentication_enabled as (
select
distinct db_cluster_identifier as name
from
aws_rds_db_cluster_snapshot
where
iam_database_authentication_enabled
group by name
),
iam_authentication_status as (
select
case
when e.name is not null then 'enabled'
else 'disabled' end as iam_authentication_status
from
aws_rds_db_cluster_snapshot as c
left join iam_authentication_enabled as e on c.db_cluster_identifier = e.name
)
select
iam_authentication_status,
count(*)
from
iam_authentication_status
group by
iam_authentication_status;

Dashboards

The query is used in the dashboards: