Hii team Need to do exceptions based alerting Can you share some clickhouse query for status code 400

cc @Srikanth Chekuri

You may not need a ClickHouse query for things such as 400 HTTP status code. You can use the query builder with metric

signoz_calls_total

and the filter

http_status_code IN 400

Can you give a heads up if we want to trigger alerts using clickhouse query?

I didn’t understand your question. What do you mean by Can you give a heads up if we want to trigger alerts using clickhouse query? Are you asking for an example ClickHouse query? A sample query is already populated if you click the exception-based alert query tab.

I mean instead of using query builder , if we want to have clickhouse queries in place. (For eg, for the graphs provided in signoz ui eg, error rate, external call to db, etc) . I want to have clickhouse queries for them

Why do you want ClickHouse queries for them?