turbot/gcp_insights

Query: kubernetes_cluster_addons_config

Usage

powerpipe query gcp_insights.query.kubernetes_cluster_addons_config

Steampipe Tables

SQL

select
case when addons_config -> 'dnsCacheConfig' ->> 'enabled' = 'true' then 'Enabled' else 'Disabled' end as "DNS Cache Config",
case when addons_config -> 'gcePersistentDiskCsiDriverConfig' ->> 'enabled' = 'true' then 'Enabled' else 'Disabled' end as "GCE Persistent Disk CSI Driver Config",
case when addons_config -> 'horizontalPodAutoscaling' ->> 'enabled' = 'true' then 'Enabled' else 'Disabled' end as "Horizontal Pod Autoscaling",
case when addons_config -> 'httpLoadBalancing' ->> 'enabled' = 'true' then 'Enabled' else 'Disabled' end as "HTTP Load Balancing",
case when addons_config -> 'kubernetesDashboard' ->> 'enabled' = 'true' then 'Enabled' else 'Disabled' end as "Kubernetes Dashboard",
case when addons_config -> 'networkPolicyConfig' ->> 'enabled' = 'true' then 'Enabled' else 'Disabled' end as "Network Policy Config"
from
gcp_kubernetes_cluster
where
id = split_part($1, '/', 1)
and project = split_part($1, '/', 2);

Dashboards

The query is used in the dashboards: