Prometheus remote read influxdb

Question

I'm new to Prometheus but familiar with Influx (currently running 1.6).

My understanding is it's possible to configure Prometheus to remotely read data from influx with the following configuration in prometheus.yml:

remote_read:
  url: "http://localhost:8086/api/v1/prom/read?db=bulkstats"

"bulkstats" is the database I'm trying to read data from in Prometheus. An example query that would work in influx would be:

SELECT "sess-curaaaactive" FROM "PDSNSYSTEM1" WHERE ("Nodename" = 'ALPRGAGQPNC') AND time >= now() - 6h"

However I cannot find one example of how to query that data from PromQL. Please help!

score 2 · Answer 1 · answered Sep 07 '19 at 07:37

2

Here is the link which matches prometheus format with influxdb's one.

In terms of prometheus's jargon, in your example, sess-curaaaactive is the metric name (measurement in influx) and ("Nodename" = 'ALPRGAGQPNC') is just a label which prometheus attaches to the measurement to create a time series.

answered Sep 07 '19 at 07:37

Saleh

1,819
1
17
44

Thanks for the info. I was looking for an equivalent PromQL query but ended up using a different method. – musca999 Oct 03 '19 at 18:22
@musca999 Sorry for asking but I'm having the exact same problem as you... How did you managed to solve it? Thanks! – Ale Sanchez Nov 03 '20 at 14:49
@Ale I never solved it. Just didn't use Prometheus. – musca999 Nov 04 '20 at 15:35
@musca999 Wow hahaha and what did you use? – Ale Sanchez Nov 04 '20 at 17:36

Prometheus remote read influxdb

1 Answers1

Linked