v.22.12Improvement

Add table_uuid column to system.parts table

Add table_uuid column to the system.parts table. #43404 (Azat Khuzhin).
Added the table_uuid column to the system.parts table in ClickHouse.

Why it matters

This feature provides a unique identifier for the table associated with each part in the system.parts table, improving traceability and management of parts across tables. It helps users to precisely identify and query parts belonging to specific tables, especially useful in environments with many tables or partitions.

How to use it

Users can query the system.parts table and reference the new table_uuid column to get the UUID of the table related to each part. For example:

SELECT name, table, table_uuid, partition
FROM system.parts
WHERE active = 1

No special configuration or enabling is required; the column is available immediately after upgrading to the version containing this feature.