Allow to Write Clickhouse Text Logs to System.text_log Table

Why it matters

This feature enables users to persist ClickHouse text log entries within a system table, making it easier to query, analyze, and manage logs using SQL. It addresses the challenge of accessing and processing logs by leveraging ClickHouse's native table infrastructure instead of external log files.

How to use it

Users can enable logging to the system.text_log table by configuring the ClickHouse server to write text logs into this system table instead of or in addition to traditional log files. After enabling, logs can be accessed and queried with standard SQL commands, for example:

SELECT * FROM system.text_log WHERE ...