Query: kubernetes_cluster_node_detail

select
  current_node_version as "Current Node Version",
  max_pods_per_node as "Max Pods Per Node",
  initial_node_count as "Initial Node Count",
  node_ipv4_cidr_size as "Node IPv4 CIDR Size",
  node_config ->> 'diskSizeGb' as "Disk Size (GB)",
  node_config ->> 'diskType' as "Disk Type",
  node_config ->> 'imageType' as "Image Type",
  node_config ->> 'machineType' as "Machine Type",
  node_config -> 'metadata' ->> 'disable-legacy-endpoints' as "Disable Legacy Endpoints",
  node_config ->> 'serviceAccount' as "Service Account",
  node_config -> 'shieldedInstanceConfig' ->> 'enableIntegrityMonitoring' as "Enable Integrity Monitoring"
from
  gcp_kubernetes_cluster
where
  id = split_part($1, '/', 1)
  and project = split_part($1, '/', 2);