v.19.1New Features

Added Functions Filesystemavailable, Filesystemfree, Filesystemcapacity

Added functions filesystemAvailable, filesystemFree, filesystemCapacity. #4097 (Boris Granveaud)
Added new functions filesystemAvailable, filesystemFree, and filesystemCapacity to retrieve filesystem space metrics.

Why it matters

These functions provide users with the ability to query available, free, and total capacity of the filesystem directly from ClickHouse, enabling better monitoring and management of disk space usage within queries.

How to use it

Use the functions filesystemAvailable(path), filesystemFree(path), and filesystemCapacity(path) by passing the desired filesystem path as an argument to get the respective space metrics.