Query: redshift_snapshot_unencrypted

select
  case when encrypted or encrypted_with_hsm then 'Enabled' else 'Disabled' end as value,
  'Encryption' as label,
  case when encrypted or encrypted_with_hsm then 'ok' else 'alert' end as "type"
from
  aws_redshift_snapshot
where
  akas::text = $1;