Join InfluxDB series and SQL Server data

Grafana InfluxDB
1
  • What Grafana version and what operating system are you using?

Grafana 10.4.1
InfluxDB 2.7.5-alpine
SqlServer 2019

  • What are you trying to achieve?

I have series in InfluxDB that represent sensors measurements. The details of these measures (from which sensor, what is measured, ect…) is stored in a SQL DB.
In grafana, I would display the measures (Influx) and as display name their description (SQL). So make a join on the column ‘measure_id’.

Exemple of serie :

image
image914×289 18.7 KB

SQL result :
image

What I want to change :
image

  • How are you trying to achieve it?

I tried to merge the queries with transformations
image

  • What happened?

image
image1028×437 25.9 KB

Any hint to display timeseries with their details from 2 different sources ?

2

Welcome to forum

You can query other data source from within influx if you are using flux query language

1 Like