Query: rds_db_cluster_snapshot_iam_authentication_enabled

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;