Query: elasticache_cluster_node_by_automatic_backup_status

select
  automatic_backup_status,
  count(*)
from (
  select snapshot_retention_limit,
    case when snapshot_retention_limit is not null then
      'enabled'
    else
      'disabled'
    end automatic_backup_status
  from
    aws_elasticache_cluster) as a
group by
  automatic_backup_status
order by
  automatic_backup_status desc;