FYI: CSV as a data source
-
- 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
-
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
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login