How to intercept all sql queries?

[gonemooncool]

I want to track all queries that go through clickhouse_connect, including “service” requests.

In driver.client.Client._init_common_settings there are some “service” queries that I cannot intercept. Is there any way to intercept any queries that go through clickhouse_connect without rewriting driver.client.Client?

[genzgd]

There is not currently a way to do that. It might make sense to add a "hook" within the query* or _raw_query Client methods to allow this sort of functionality.

[joe-clickhouse]

Hi @gonemooncool I'm taking a look through some older issues. Are you still interested in this? If so, have you tried ClickHouse's system.query_log? I think it can include the driver's initialization queries too, depending on the server's logging configuration.

Would that query history cover your needs? Or do you need to capture queries directly in your application as they're sent?

If you need them in the application, what would you use them for? E.g., ordinary logging, tracing....? This would help decide whether query logging, a user-supplied callback, or even OpenTelemetry support would be the best fit.