turbot/gcp_compliance

Query: kubernetes_cluster_with_less_than_three_node_auto_upgrade_enabled

Usage

powerpipe query gcp_compliance.query.kubernetes_cluster_with_less_than_three_node_auto_upgrade_enabled

Steampipe Tables

SQL

select
self_link resource,
case
when np -> 'management' -> 'autoUpgrade' = 'true' and current_node_count < 3 then 'alarm'
else 'ok'
end as status,
title || ' has ' || current_node_count || ' node(s) with auto upgrade enabled.' as reason
, location as location, project as project
from
gcp_kubernetes_cluster,
jsonb_array_elements(node_pools) as np;

Controls

The query is being used by the following controls: