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
  and subscription_id = split_part($1, '/', 3);