How to use json functions provided by sqite3 in grafana with sqlite plugin?

Hi, I have a sqlite database, which I would like to use as a data source for my grafana panels. My table in sqlite has a column called execution_data which stores a json object. I have installed sqlite plugin (SQLite plugin for Grafana | Grafana Labs) and setup the data source in grafana. Issue here is when I try to access the values inside json object of execution_data column form terminal it works fine (shown in finding values from json field.png). But, when I try to get the same values from grafana query editor it is showing that there is no function called json_extract (shown in json error in grafana.png).

Is there any way to deal with json objects present in the database using this plugin or any other plugin?

This topic was automatically closed after 365 days. New replies are no longer allowed.