turbot/gcp_insights

Query: pubsub_topics_for_kubernetes_cluster

Usage

powerpipe query gcp_insights.query.pubsub_topics_for_kubernetes_cluster

SQL

select
t.self_link as topic_name
from
gcp_kubernetes_cluster c,
gcp_pubsub_topic t
where
c.id = $1
and c.notification_config is not null
and t.project = c.project
and t.self_link like '%' || (c.notification_config -> 'pubsub' ->> 'topic') || '%';