Query: kubernetes_cluster_auto_repair_status

select
  status,
  count(*)
from
  (
    select
      name,
      case
        when np -> 'management' -> 'autoRepair' = 'true' then 'enabled'
        else 'disabled'
      end status
    from
      gcp_kubernetes_cluster,
      jsonb_array_elements(node_pools) as np
  ) as c
group by
  status
order by
  status;