v.25.4New Feature

Introduce a new column, parametrized_view_parameters in system

Introduce a new column, parametrized_view_parameters in system.tables. Closes https://github.com/clickhouse/clickhouse/issues/66756. #75112 (NamNguyenHoai).
Introduces a new column parametrized_view_parameters in the system.tables system table to expose parameters of parametrized views.

Why it matters

This feature addresses the need for visibility into the parameters of parametrized views by adding a dedicated column in the system.tables table. It helps users and administrators easily query and inspect the parameters used by parametrized views, improving management and debugging capabilities.

How to use it

Users can query the system.tables table and check the new parametrized_view_parameters column to retrieve the parameters defined for parametrized views. For example:
SELECT database, name, parametrized_view_parameters FROM system.tables WHERE engine = 'ParametrizedView'