Hello there!
I want to have a table in Grafana with dynamic number of rows to monitor current data in database.
Before that, it worked through SQL-authentification and there was a single SQL datasource that enabled me to write query directly for Grafana table dashboard.
But right now I have to do it through windows authentification and Zabbix datasource, but i can not authentify directly in Grafana, because server is not Windows.
I was trying to figure out, how to extract fields and rows from a single text field in the table in Grafana. Still had no luck.
I’m monitoring Sql Database with Zabbix. I have an item in Zabbix, that returns a JSON-string as a single text string.
I had to do it this way, because, apparently, Zabbix can not return you a set of database rows.
I have tried multiple ways of extracting fields from the main field, but there is no way to do that, because i can not split this json into ROWS.
I can split each json object into different fields, but that does not help, because, apparently, you cant transform fields to rows for JSON format.
Thanks for sharing the screenshot. I see the following 2 problems.
The warning message about the “Angular Plugin” means that you might be using an older version of the plugin. Therefore please update to the latest one and you can follow this GitHub issue link for more information if required
About the splitting of the JSON data. Well, you are using the correct transformation but if that does not help then it means that it is not possible solely by Grafana to do it as it is a backend case. Since the Zabbix plugin only can show the unparsed JSON data, as it does not have any filtering option. Therefore, you can try to get the data that you only need to view instead of the whole OR you can ask this question at the GitHub issue as whether it can be a feature request.
Also, I found this similar post which might help your case:
