Hello,
I would like to ask if is possible to set the value of a variable from grafana and save that value in the selected datasource.
Thank you.
2 years later, hope it can help someone.
Actually, we are also looking for a good solution.
The main problem I see is that Grafana runs the queries all the time. Because nothing prevents you from using INSERT or UPDATE statements instead of SELECT statements. However usually you do not want to have those statements run all the time, but just, when you hit a save button or something similar.
What we do right now:
We use one panel just for saving the data. On dashboard start that panel is hidden and as soon as the user opens it, the data out of the variables is saved via an INSERT statement.
That solution is not great, I know. As I sad, we are looking for something better.