v.25.11Improvement

Show table properties in Web UI

Official CH changelog text
Show table properties in Web UI. Clicking on the number of rows or bytes will bring up a query from system.tables. Clicking on the table engine will bring up SHOW TABLES. #89771 (Alexey Milovidov).
Show table properties such as the number of rows, bytes, and table engine directly in the ClickHouse Web UI with interactive elements.

Why it matters

This feature enhances the ClickHouse Web UI by providing users quick access to table metadata and related queries. Clicking on the displayed number of rows or bytes executes a query from system.tables, while clicking on the table engine triggers a SHOW TABLES query. This helps users easily inspect table details and related information without manually writing queries.

How to use it

In the ClickHouse Web UI, navigate to the tables list view. Click on the displayed values for number of rows or bytes to see detailed data from system.tables. Click on the table engine name to run a SHOW TABLES query automatically. No additional configuration is required.

Related resources

PreviousNext