turbot/aws_compliance

Query: glue_data_catalog_encryption_settings_password_encryption_enabled

Usage

powerpipe query aws_compliance.query.glue_data_catalog_encryption_settings_password_encryption_enabled

SQL

select
'arn:' || partition || '::' || region || ':' || account_id as resource,
case
when connection_password_encryption is not null
and connection_password_encryption ->> 'ReturnConnectionPasswordEncrypted' != 'false' then 'ok'
else 'alarm'
end as status,
case
when connection_password_encryption is not null
and connection_password_encryption ->> 'ReturnConnectionPasswordEncrypted' != 'false' then 'Glue data catalog connection password encryption enabled in ' || region || '.'
else 'Glue data catalog connection password encryption disabled in ' || region || '.'
end as reason,
region,
account_id
from
aws_glue_data_catalog_encryption_settings;

Controls

The query is being used by the following controls: