turbot/gcp_insights

Query: kms_keys_for_kubernetes_cluster

Usage

powerpipe query gcp_insights.query.kms_keys_for_kubernetes_cluster

SQL

select
k.self_link
from
gcp_kubernetes_cluster c,
gcp_kms_key k
where
c.database_encryption_key_name is not null
and c.database_encryption_key_name <> ''
and k.project = c.project
and k.self_link like '%' || c.database_encryption_key_name
and c.id = split_part($1, '/', 1);