v.24.11New Feature

Added SQL Syntax for Workload and Resource Management

Added SQL syntax to describe workload and resource management. https://clickhouse.com/docs/operations/workload-scheduling. #69187 (Sergei Trifonov).
Added SQL syntax to describe workload and resource management in ClickHouse.

Why it matters

This feature enables users to define and control workload scheduling and resource allocation directly using SQL syntax. It addresses the need for fine-grained management of query execution priorities and resource usage to improve cluster performance and fairness.

How to use it

Users can use the new SQL syntax to configure workload and resource management policies as documented. This involves writing SQL statements that specify workload types, resource groups, and scheduling rules as per the official documentation.