turbot/aws_insights

Query: rds_db_instance_snapshot_iam_authentication_enabled

Usage

powerpipe query aws_insights.query.rds_db_instance_snapshot_iam_authentication_enabled

Steampipe Tables

SQL

with iam_authentication_enabled as (
select
distinct db_instance_identifier as name
from
aws_rds_db_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_database_authentication
from
aws_rds_db_snapshot as c
left join iam_authentication_enabled as e on c.db_instance_identifier = e.name
)
select
iam_database_authentication,
count(*)
from
iam_authentication_status
group by
iam_database_authentication;

Dashboards

The query is used in the dashboards: