turbot/gcp_insights

Query: storage_bucket_encryption_table

Usage

powerpipe query gcp_insights.query.storage_bucket_encryption_table

SQL

select
b.name as "Name",
b.id as "ID",
case
when default_kms_key_name is null then 'Google Managed'
else 'Customer Managed'
end as "Encryption Type",
b.default_kms_key_name as "KMS Key",
b.project as "Project",
b.location as "Location",
b.self_link as "Self-Link",
k.self_link as "KMS Self-Link"
from
gcp_storage_bucket as b
left join gcp_kms_key as k
on k.self_link like '%' || b.default_kms_key_name
order by
b.name;

Dashboards

The query is used in the dashboards: