Query: kubernetes_cluster_agent_pools

select
  p ->> 'name' as "Name",
  p ->> 'count' as "Node Count",
  p ->> 'enableAutoScaling' as "Autoscaling Enabled",
  p ->> 'enableNodePublicIP' as "Is Public",
  p ->> 'osDiskSizeGB' as "OS Disk Size (GB)",
  p ->> 'osDiskType' as "OS Disk Type",
  p ->> 'osType' as "OS Type",
  p ->> 'vmSize' as "VM Size"
from
  azure_kubernetes_cluster c,
  jsonb_array_elements(c.agent_pool_profiles) p
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3)
order by
  p ->> 'name';