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

go to your metabase app mkdir /app/data/sqlite upload mySQLITE.sqlite to /app/data/sqlite/ go to admin -> add database choose sqlite as the driver choose /app/data/sqlite/mySQLITE.sqlite as filename

New important step:

go to admin/datamodel/data and choose your DB choose the right TYPE for your column

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)
etc.

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.