-
What Grafana version and what operating system are you using?
Grafana version 8.1.5
SQLite plugin version 2.1.0 (frser-sqlite-datasource)
MacOS Big Sur 11.5.1 -
What are you trying to achieve?
Creating a simple line chart by fetching time and value from a SQLite DB -
How are you trying to achieve it?
I created a new panel and use this query to fetch data
WITH converted AS (
SELECT future_oi_abs, date || ‘T00:00:00Z’ AS datetime FROM fao_mkt_summary where symbol = “$symbol”
)
SELECT datetime, future_oi_abs FROM converted ORDER BY datetime ASC
-
What happened?
The query shows - no data in response. Inspector shows the right query but no data
-
What did you expect to happen?
Same query, run directly on SQLite DB returns results.
The DB exists and Grafana connects to it fine. The variable $symbol that currently has value ACC has been extracted from the very same DB.
Can someone please point me to what am I missing? Why would query run fine directly on DB but fail via Grafana.