Data transport between panels

I’m working with Grafana and using business forms ( volkov labs ) to handle dynamic queries. I currently have one panel that constructs a large SQL query using JavaScript, which is then stored in a Grafana variable. This variable is used by another panel to execute the query against a PostgreSQL database ( ex: ${report:query}). However, I’m looking for a more efficient way to transfer this large query from one panel to another without relying on Grafana variables. My goal is to find a method that can handle large text transfer while maintaining good performance on Grafana’s variable system. Any suggestions or best practices for this scenario would be greatly appreciated!

@mikhailvolkov @volkdimitr

@nassarissa74 I think using variables is your best option.

Other options to consider:

  • use data source to store input data and a stored function to retrieve data.
  • use JSON with input data in variable instead of SQL query and stored function to retrieve data based on JSON.
1 Like