v.18.4New Feature

Added System Tables: formats, data_type_families, aggregate_function_combinators, table_functions, table_engines, collations

Added system tables: formats, data_type_families, aggregate_function_combinators, table_functions, table_engines, collations #2721.
Introduced several new system tables including formats, data_type_families, aggregate_function_combinators, table_functions, table_engines, and collations to provide detailed metadata and enhance introspection capabilities in ClickHouse.

Why it matters

These system tables allow users and administrators to easily query and explore available data formats, data type categories, aggregate function combinators, table functions, table engines, and collations within ClickHouse. This improves the transparency of internal components and helps in writing more informed queries and managing database configurations.

How to use it

Users can query these new system tables directly using SELECT statements, for example:

SELECT  FROM system.formats;
SELECT
FROM system.table_engines;


These tables are accessible without any additional configuration, providing immediate insight into the respective categories.