How to join Prometheus query to reference data

[leandrodotec]

I have a Prometheus query:

your_metric{ host_name=~".+"}

and I have a CSV file like:

id,lane_number,client,host_name
1,"01",clientA,host1
2,"05",clientB,host2
3,"07",clientA,host3

I want to join prometheus query with my CSV table and generate a time timeseries that has the Client coming from the CSV and the values coming from your_metric{ host_name=~".+"}.

Is this possible?

I setup a Reference source so I can do this:

I tried with join, but didn't work:

and this is my Prometheus. I want to display the "Lane number" and "Client" from my CSV file.

[zoltanbedi]

It is and I think the easiest way is to try with https://grafana.com/docs/grafana/latest/panels-visualizations/query-transform-data/sql-expressions/

[leandrodotec]

I ended up finding the solution:
Change the Prometheus query to Format: Table
Add a "Join by field" transformation, mode "inner"

The trick was to change the Format from TimeSeries to Table.
(after a few days of trying all options available)

I haven't tried @zoltanbedi's answer, but it does look promising too.