01-20-2025 09:20 AM
To ensure you are only counting active worker nodes, you can use:
SELECT COUNT(DISTINCT instance_id)
FROM system.compute.node_timelines
WHERE cluster_id = 'xx'
AND driver = false
AND end_time IS NULL
