turbot/digitalocean_insights

Query: kubernetes_cluster_by_auto_upgrade_status

Usage

powerpipe query digitalocean_insights.query.kubernetes_cluster_by_auto_upgrade_status

SQL

with cluster as (
select
case
when not auto_upgrade then 'disabled'
else 'enabled'
end as u_status
from
digitalocean_kubernetes_cluster
)
select
u_status,
count(*) as "Clusters"
from
cluster
group by
u_status;

Dashboards

The query is used in the dashboards: