turbot/gcp_compliance

Query: alloydb_cluster_encrypted_with_cmk

Usage

powerpipe query gcp_compliance.query.alloydb_cluster_encrypted_with_cmk

Steampipe Tables

SQL

select
self_link resource,
case
when encryption_info ->> 'encryptionType' = 'CUSTOMER_MANAGED_ENCRYPTION' then 'ok'
else 'alarm'
end as status,
case
when encryption_info ->> 'encryptionType' = 'CUSTOMER_MANAGED_ENCRYPTION' then title || ' encrypted with customer-managed encryption keys.'
else title || ' encrypted with Google-managed encryption keys.'
end as reason
, location as location, project as project
from
gcp_alloydb_cluster;

Controls

The query is being used by the following controls: