v.24.9New Feature

Add system.projections table for tracking available projections

Add system.projections table to track available projections. #68901 (Jordi Villar).
Added the system.projections table to track all available projections in ClickHouse.

Why it matters

This feature provides users with a centralized system table to view and monitor all the projections defined in their ClickHouse database, improving transparency and manageability of projection usage.

How to use it

Access the system.projections table by running a query like SELECT * FROM system.projections to list all available projections and their details.