turbot/gcp_insights

Query: compute_firewalls_for_kubernetes_cluster

Usage

powerpipe query gcp_insights.query.compute_firewalls_for_kubernetes_cluster

SQL

select
f.id::text as firewall_id
from
gcp_kubernetes_cluster c,
gcp_compute_network n,
gcp_compute_firewall f
where
c.network = n.name
and c.project = n.project
and n.self_link = f.network
and c.id = split_part($1, '/', 1);