turbot/gcp_insights

Query: kms_keys_for_storage_bucket

Usage

powerpipe query gcp_insights.query.kms_keys_for_storage_bucket

SQL

select
k.self_link
from
gcp_storage_bucket b,
gcp_kms_key k
where
b.id = split_part($1, '/', 1)
and b.project = split_part($1, '/', 2)
and b.default_kms_key_name is not null
and k.self_link like '%' || b.default_kms_key_name;