SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.

SigNoz Community

hi does signoz allow for you to set up SQL queries to pull data in  and monitor for changes in that sql output?

<@U03TH4WE80P> Can you share more details on what you mean? Are you talking about querying telemetry data using SQL? What type of changes in SQL output you want to monitor

these are more like functional metrics ...

say all our jobs log their status to a db table

and i want to monitor the status of all the thousands of jobs  ... so i want to query that table and see which jobs have failed and alert on them

got it. <@U01NT95GV8B> do you have insights on if this can be done or not

<@U03TH4WE80P> Yes, you can make use of sqlquery receiver <https://github.com/open-telemetry/opentelemetry-collector-contrib/tree/main/receiver/sqlqueryreceiver#configuration> and ingest the metric data into SigNoz then you can work with this data as would do with regular infra/application metrics.

Depending on your deployment type you need to configure the pipeline with this receiver in `.../otel-collector-config.yaml` and it should work.