v.24.4Improvement

Use system.keywords for Suggestions and Internal Consistency

Official CH changelog text
Use system.keywords to fill in the suggestions and also use them in the all places internally. #62000 (Nikita Mikhaylov).
Introduced the system.keywords table to provide keyword suggestions and unify their usage internally across ClickHouse.

Why it matters

This feature centralizes the management of ClickHouse keywords by using the system.keywords table both for generating query suggestions and for internal keyword handling, improving consistency and user experience when writing queries.

How to use it

Users can query the system.keywords table to get a list of supported keywords for query suggestions. This table is used internally by ClickHouse, so no additional configuration is required to benefit from unified keyword handling.

Related resources

PreviousNext