v.22.5New Feature

Added system.certificates table

Added system.certificates table. #37142 (Yakov Olkhovskiy).
Added the system.certificates table to ClickHouse.

Why it matters

This feature provides users with a system table that lists information about SSL/TLS certificates used by ClickHouse. It simplifies monitoring, auditing, and managing certificates by exposing their details directly via SQL queries.

How to use it

Users can query the system.certificates table using a SELECT statement to retrieve information about the currently configured certificates. For example:

SELECT * FROM system.certificates