system.storage_policies

Contains information about storage policies and volumes defined in the server configuration.

Columns:

• policy_name (String) — Name of the storage policy.
• volume_name (String) — Volume name defined in the storage policy.
• volume_priority (UInt64) — Volume order number in the configuration.
• disks (Array(String)) — Disk names, defined in the storage policy.
• max_data_part_size (UInt64) — Maximum size of a data part that can be stored on volume disks (0 — no limit).
• move_factor (Float64) — Ratio of free disk space. When the ratio exceeds the value of configuration parameter, ClickHouse start to move data to the next volume in order.

If the storage policy contains more then one volume, then information for each volume is stored in the individual row of the table.

Original article