v.23.9Improvement

New Field 'data_length' Added to information_schema.tables for Disk Size Approximation

Official CH changelog text
View information_schema.tables now has a new field data_length which shows the approximate size of the data on disk. Required to run queries generated by Amazon QuickSight. #55037 (Robert Schulze).
The information_schema.tables system view now includes a new field data_length that provides the approximate size of table data on disk.

Why it matters

This feature addresses the need for tools like Amazon QuickSight to retrieve table size information directly from ClickHouse, enabling better integration and more informed query generation based on data volume.

How to use it

Users can query the information_schema.tables view and select the data_length field to obtain the approximate disk size of each table's data. No additional configuration is required.

Related resources

PreviousNext