turbot/gcp_compliance

Query: bigquery_table_encrypted_with_cmk

Usage

powerpipe query gcp_compliance.query.bigquery_table_encrypted_with_cmk

Steampipe Tables

SQL

select
self_link resource,
case
when kms_key_name is null then 'alarm'
else 'ok'
end as status,
case
when kms_key_name is null then title || ' encrypted with Google managed cryptographic keys.'
else title || ' encrypted with customer-managed encryption keys.'
end as reason,
location as location,
project as project
from
gcp_bigquery_table;

Controls

The query is being used by the following controls: