Query: kubernetes_cluster_zone_redundant

select
  self_link resource,
  case
    when zone is not null
    and jsonb_array_length(locations) >= 3 then 'ok'
    else 'alarm'
  end as status,
  case
    when zone is not null
    and jsonb_array_length(locations) >= 3 then title || ' zone redundant.'
    else title || ' not zone redundant.'
  end as reason,
  location as location,
  project as project
from
  gcp_kubernetes_cluster;