v.25.7New Feature

System.formats table now contains extended information about

The system.formats table now contains extended information about formats, such as HTTP content type, the capabilities of schema inference, etc. #81505 (Alexey Milovidov).
The system.formats table now provides extended metadata about data formats, including HTTP content types and schema inference capabilities.

Why it matters

This feature enhances the system.formats table to help users better understand various data formats supported by ClickHouse. By providing details such as HTTP content type and whether schema inference is supported, users can make more informed decisions when working with data import/export and integration scenarios.

How to use it

Users can query the system.formats table to retrieve extended information about available data formats. For example, use SELECT * FROM system.formats to see the HTTP content type and schema inference capabilities alongside other format properties.