Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-21-2025 05:22 AM - edited 01-21-2025 05:25 AM
try this
SELECT
cluster_id,
MAX(max_autoscale_workers) AS max_workers,
DATE_TRUNC('day', change_time) AS day
FROM
system.compute.clusters
WHERE
change_time BETWEEN '2023-01-01' AND '2023-01-31'
GROUP BY
cluster_id,
DATE_TRUNC('day', change_time)
ORDER BY
day;
