v.25.12Improvement

Add dependencies and missing_dependencies columns to system

Added dependencies and missing_dependencies columns to system.kafka_consumers to report materialized view target tables for Kafka tables. Added KafkaMVNotReady counter. #85346 (Ilya Golshtein).
Added dependencies and missing_dependencies columns to system.kafka_consumers to report materialized view target tables for Kafka tables, along with a new KafkaMVNotReady counter.

Why it matters

This feature improves the visibility and monitoring of materialized views associated with Kafka engine tables by reporting their dependent tables and identifying missing dependencies. The KafkaMVNotReady counter helps track readiness status, enabling users to diagnose and manage Kafka materialized views more effectively.

How to use it

Query the system.kafka_consumers table to view the new dependencies and missing_dependencies columns which list the target tables for Kafka materialized views and any missing dependencies, respectively. Monitor the KafkaMVNotReady counter to check the readiness state of Kafka MVs.