v.22.12Improvement
Add table_uuid column to system.parts table
Addtable_uuidcolumn to thesystem.partstable. #43404 (Azat Khuzhin).
Why it matters
This feature provides a unique identifier for the table associated with each part in thesystem.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 thesystem.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 = 1No special configuration or enabling is required; the column is available immediately after upgrading to the version containing this feature.