v.25.6New Feature

Add a new system table system

Official CH changelog text
Added a new system table system.codecs to introspect the available codecs. (issue #81525). #81600 (Jimmy Aguilar Mena).
Added a new system table system.codecs that allows users to introspect all available codecs in ClickHouse.

Why it matters

This feature provides users with an easy way to query and explore the codecs supported by ClickHouse, helping them to understand data compression options and make informed decisions when defining table schemas or optimizing storage.

How to use it

Users can query the new system table by running a SQL statement such as:

SELECT * FROM system.codecs;

This will return information about all codecs available in the ClickHouse instance.

Related resources

PreviousNext