v.24.7New Feature

Add System Tables for Detached Table Information

Add system tables with main information about all detached tables. #65400 (Konstantin Morozov).
Added new system tables that provide detailed information about all detached tables in ClickHouse.

Why it matters

Detached tables can accumulate over time and require monitoring for maintenance and troubleshooting. This feature helps users easily inspect and manage detached tables by exposing their status and metadata through dedicated system tables.

How to use it

Users can query the new system tables to retrieve information about detached tables using standard SELECT statements. No additional configuration is needed to enable this feature.