What is the simplest way to access a few rows of text (let them be files or DB table)

I just need to access a list of a few strings, that must be stored somewhere in order to query them.
What would be the simplest way to do that? To create a 1-table DB? To write a file? And then, how to access it? Which datasource to use?
I’m using Grafana v11.0.1 on macOS Sequoia.
I cannot store them as a constant or a custom variable, because I then need to access them from a panel depending on the selected value of a custom variable.
i.e.
I have defined a custom variable X whose value is: a,b,c,d
Depending on the selected value of variable X, I need to access a list of strings(s1,s2,s3); afterwards, I’m going to repeat panels while iterating over that list.
So, whenever I select X=a, I expect a datasource to retrieve those string values (s1,s2,s3) and do something with them.

Actually you can store them as variables unless they are dynamic

you just have to create the relationship (as you would in a database table parent child relationship) within the variables

X variable setup

Y variable setup with infinity and Uql to be able to filter based on X

1 Like