do you have an example where SigNoz uses an SQL exporter (like https://github.com/chop-dbhi/prometheus-sql) to monitor a database?

I think all you'd need to do is have the receiver send metrics to the Otel Collector ip on port 4318

@Blake Romano No. 4318 is for protobuf over http for push based exporters with OTLP protocol. @Jason Harrison You should be able get it work by adding your target to this scrape_configs list https://github.com/SigNoz/signoz/blob/develop/deploy/docker/clickhouse-setup/otel-collector-metrics-config.yaml#L10.

@Blake Romano a node level otel-collector using prometheus receiver and exporting it to signoz's otel-collector at either of ports 4317 or 4318 depending on your choice of grpc vs http. Right @Srikanth Chekuri?

Today signoz runs two instances of collector. One for the push based and other for the pull based metrics both of which directly write to clickhouse. The applications that want to send the metrics using OTLP protocol can directly send or use a node level collector as an intermediary to send data to signoz collector using grpc/http. And the other instance is used as promethes scraper which reads the data from targets. The above linked yaml is where they are configured.

Thank you!