v.23.5Improvement

Add Size Suffix Support in Quota Creation Parameters

Add support for size suffixes in quota creation statement parameters. #49087 (Eridanus).
Added support for size suffixes in parameters of the quota creation statement in ClickHouse.

Why it matters

This feature allows users to specify sizes with human-readable suffixes (such as KB, MB, GB) when defining quotas, simplifying configuration and improving clarity compared to specifying raw byte numbers.

How to use it

When creating or altering quotas using the CREATE QUOTA or ALTER QUOTA statements, users can now append size suffixes to parameters that represent size limits. For example:

CREATE QUOTA example_quota
KEYED BY user_key
FOR INTERVAL 1 DAY MAX_QUERY_SIZE 10MB;