09/23/2022, 3:36 PM
hi does signoz allow for you to set up SQL queries to pull data in and monitor for changes in that sql output?
09/23/2022, 4:10 PM
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
09/23/2022, 6:35 PM
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
09/23/2022, 11:34 PM
do you have insights on if this can be done or not
09/24/2022, 1:55 AM
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.
Depending on your deployment type you need to configure the pipeline with this receiver in
and it should work.