Join InfluxDB series and SQL Server data

  • 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 :

SQL result :

What I want to change :

  • How are you trying to achieve it?

I tried to merge the queries with transformations

  • What happened?

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

Welcome to forum

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

1 Like