Query: kubernetes_cluster_public_access_status

select
  'Public Access' as label,
  case
    when api_server_access_profile ->> 'authorizedIPRanges' is null
    and api_server_access_profile ->> 'enablePrivateCluster' = 'false' then 'Enabled'
    else 'Disabled'
  end as value,
  case
    when api_server_access_profile ->> 'authorizedIPRanges' is null
    and api_server_access_profile ->> 'enablePrivateCluster' = 'false' then 'alert'
    else 'ok'
  end as type
from
  azure_kubernetes_cluster
where
  lower(id) = $1;