v.20.6Improvement

Added 'type' column in system.disks

Added 'type' column in system.disks. #12115 (ianton-ru).
Added a new type column to the system.disks table in ClickHouse.

Why it matters

This feature provides more detailed information about the disks used by ClickHouse by exposing the disk type directly in the system.disks table. It helps users better understand the storage configuration and aids in troubleshooting and performance tuning.

How to use it

To use this feature, query the system.disks table and include the new type column in your SELECT statements, for example:
SELECT name, path, type FROM system.disks