FYI: CSV as a data source

[luckow]

• Download csv-metabase-driver https://github.com/Markenson/csv-metabase-driver/releases
• upload the jar file to /app/data/plugins
• upload your csv file to /app/data/csv/ (or something similar)
• reload the app
• (logout /) login to the app as an admin
• go to admin -> add database
• choose your new csv driver
• choose /app/data/csv as "filename" (important: don't use the mycsv.csv in "filename")
• fill in the seperator and charset
• save
• have fun with metabase & your csv file

[luckow]

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