Configure sqlite3 data source to load extension

Grafana Configuration
1

Is there a way to configure sqlite3 data source to load an extension?
Standard load extension command select load_extension(‘./define’); throws error:“SQL logic error: not authorized (1)”

2

did you configure things on sqllite side

https://www.sqlite.org/c3ref/load_extension.html

3

A standalone instance of sqlite3 is working fine, as shown below

sqlite> select load_extension('./pivotvtab');

sqlite> create virtual table v_sales using pivot_vtab (
(x1...>   (select distinct product from sales where product in ("alpha", "beta")),
(x1...>   (select distinct year, year from sales),
(x1...>   (select sum(income) from sales where product = ?1 and year = ?2)
(x1...> );
sqlite>
sqlite> select * from v_sales;
alpha|100.0|120.0|130.0|140.0
beta|10.0|20.0|40.0|80.0
sqlite>

when load_extension is used in grafana (with sqlite plugin) it throws error.

rawQueryText:"select load_extension('./pivotvtab.dll');"
....
....
error:"**SQL logic error: not authorized (1)**"
4

where is the db file in relation to grafana
what os is grafana on, and what folder

5

db file is in GrafanaLabs\grafana\data folder on windows.
extension file (.dll) is also placed in same same folder and have tried placing almost all folder I may possibly think about.

6

It appears that sqlite plugin “frser-sqlite-datasource” is configured not to allow extension. Is there any mechanism to tweak the plugin to allow loading extension.

7

best to contact author of plugin on github