turbot/aws_insights

Query: redshift_snapshot_unencrypted

Usage

powerpipe query aws_insights.query.redshift_snapshot_unencrypted

Steampipe Tables

SQL

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;

Dashboards

The query is used in the dashboards: