Cascaded Dashboard Variables with Infinity Datasource (CSV)

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


  • What are you trying to achieve?

Using an external Source with “Description”,“host”,“interface” to use as Dashboard Variables . The User should select the Description, the InfluxDB Query needs “host” and “interface” .

I got this working with 3 Postgres SQL Display variable queries, like .

query0 = select description from table

myinterface = select interface from table where description like ‘$query0’
myhost = select host from table where description like ‘$query0’

So if the user Select the Description i could use the variables myhost,myinterface in the flux query.

All good, but now we are forced to gather this info from a http CSV …

  • How are you trying to achieve it?

Using Infinity CSV Plugin for Casaded Dashboard Varialbes .

  • What happened?

Simple do not get it working .
Not found a way to filter on another column then the one used for the variable
Tried UQL but simply failed not to know how to define the delimiter . ( semicolon )
Plugin works as the Backend/Default query shows correct results.

  • What did you expect to happen?

A way to Build Casacade Dashboard Variables from a http CSV source .

  • Can you copy/paste the configuration(s) that you are having problems with?

csv looks like this

“[this is the description]some other text”,“hosta”,“interfacea”,“someother fields not needed”
“[this is another description]some other text”,“hostb”,“interfaceb”,“someother fields not needed”

I was able to regex out the needed description in the Brackets . For the first query .

But now i dont know how the get the myhost / myinterface variables defined with a lookup .

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

Not really .

  • Did you follow any online instructions? If so, what is the URL?

I have tried to find a solution , but no .

Any help would be real great .

Thx, Dietmar