Add Home Assistant SQLite DB as Grafana Data Source

Configuration
1

Hello,

I have Grafana installed on my Home Assistant Green device. I want to use the default SQLite DB as a data source. However, when I attempt to “Save & test” the connection with the path to /config/home_assistant_v2.db and the path prefix set to “file:”, I receive the following error:

error checking db: error checking for valid SQLite file: unable to open database file (14)

When I run ls -l /config/home-assistant_v2.db, I see

-rw-r--r-- 1 root root [date] /config/home-assistant_v2.db

Why can’t Grafana add the SQLite DB as the data source?

2

This request needs to be made to Grafana It’s not a Home Assistant Problem. But I would guess it’s because it needs a time based database like Influx to work,