After playing around with csv & metabase for a few hours, I searched for a better solution, because of performance and some limitations (some date filters doesn't work with csv).
This is a perfect little helper tool. https://github.com/rufuspollock/csv2sqlite
csv2sqlite.py myCSV.csv mySQLITE.sqlite
New important step:
Then the real magic happens 🙂
Thanks for looking into this and apologies for not following up - need to check my notification settings. (also work has been really busy so no mental energy for looking at my outside interests!)
This is Cloudron. Self hosting. Including databases.
How do we make it easier to get data in, suck it into a database of choice and easily point Metabase and other tools at it?
If we do this right, we come up with our own data handling stack like LAMP is for the web.
Cloudron, RebaseData, Postgres, Metabase (CPRM)
Linux, RebaseData, Mysql, Metabase (LRMM)
It is already pre-configured using the env variables mentioned in the settings UI (MB_EMAIL_...)
Similar with many other apps, ideally we could hide/change that UI part in the settings page to not be as confusing.