We are looking for way to combine IOT data stored in Influx with metadata stored in a relational DB (could be MySql, PostgreSQL, etc.) in Grafana. Our data stored in Influx is structured like:
Timestamp, DeviceID, SensorID, Value
An example of metadata would be something like:
DeviceID (Primary key), Manufacturer
Is there a way we could join the two queries together in Grafana so we could use the Timestamp, DeviceID, SensorID, Value and Manufacturer in a single graph? If not, how is this scenario typically handled with Grafana?