v.21.6Improvement

Add broken data file metrics to system.distribution_queue

Add broken_data_files/broken_data_compressed_bytes into system.distribution_queue. Add metric for number of files for asynchronous insertion into Distributed tables that has been marked as broken (BrokenDistributedFilesToInsert). #23885 (Azat Khuzhin).
Added new metrics broken_data_files and broken_data_compressed_bytes to the system.distribution_queue table for Distributed tables asynchronous inserts.

Why it matters

To provide visibility into the number and size of data files marked as broken during asynchronous insertion into Distributed tables, helping users monitor and troubleshoot ingestion issues.

How to use it

Query the system.distribution_queue system table to inspect the new columns broken_data_files and broken_data_compressed_bytes. These metrics reflect the count and compressed byte size of files marked as broken, identified by the BrokenDistributedFilesToInsert metric.