Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Metabase
  3. FYI: CSV as a data source

FYI: CSV as a data source

Scheduled Pinned Locked Moved Metabase
2 Posts 1 Posters 518 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • luckowL Offline
    luckowL Offline
    luckow
    translator
    wrote on last edited by
    #1
    • 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

    Pronouns: he/him | Primary language: German

    1 Reply Last reply
    3
    • luckowL Offline
      luckowL Offline
      luckow
      translator
      wrote on last edited by
      #2

      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 🙂

      Pronouns: he/him | Primary language: German

      1 Reply Last reply
      2
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • Bookmarks
      • Search