hi does signoz allow for you to set up SQL queries to pull d

Question

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

Pranay · Answer

< Kim Ong> 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

Kim Ong · Answer

these are more like functional metrics

Kim Ong · Answer

say all our jobs log their status to a db table

Kim Ong · Answer

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

Pranay · Answer

got it < Srikanth Chekuri> do you have insights on if this can be done or not

Srikanth Chekuri · Answer

< Kim Ong> Yes you can make use of sqlquery receiver and ingest the metric data into SigNoz then you can work with this data as would do with regular infra application metrics

Srikanth Chekuri · Answer

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