Query: rds_db_instance_snapshot_iam_authentication_enabled

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;