Hey there,
might be a stupid question, but is there any way to have some AI model like Gemini analyze historical Home Assistant data ?
I am running an influxDB and would like to find correlations, trends and so on to optimize my enviroment.
Thanks ahead
InfluxDB stores Long Term Statistic.
The values stored in LTS are calculated values per hour, so with a resolution of one hour you can really only way something about changes based on years and you would need several years of data to do that.
In order to say anything on a finer scale you would need the Short Term data, which is default stored in the SQLite file and typically only for around 2 weeks.
You will need several weeks more and that can be a huge amount, even with a well managed recorder in HA.
A SQLite file will be risky with those data amounts. MariaDB could be a resolution to improve the handling of the data.
If you do not manage your recorder settings tightly in HA then you will probably fast have many GB of data and you need to keep managing it,if you do not use an exclude all, except include specific approach. New sensor might otherwise get included in the database and the size will take of again.