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


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
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

Cloudron Forum

Apps | Demo | Docs | Install

Metabase and Baserow

Scheduled Pinned Locked Moved Metabase
5 Posts 5 Posters 414 Views
    • 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.
  • alex-a-sotoA Offline
    alex-a-sotoA Offline
    alex-a-soto
    wrote on last edited by
    #1

    Hi Cloudron team,

    I'm interested in using Metabase and Baserow together. From what I understand, Baserow uses PostgreSQL, and PostgreSQL is one of the official data sources supported by Metabase.

    Could it be possible to connect both of these applications in Cloudron?

    Thank you for your time and support.

    Regards,
    Alex

    girishG J timconsidineT 3 Replies Last reply
    2
  • girishG Offline
    girishG Offline
    girish Staff
    replied to alex-a-soto on last edited by
    #2

    @alex-a-soto Yes, if they are on the same server, you can put Baserow's postgres credentials into metabase. Just go into Baserow's Web Terminal and run env | grep POSTGRESQL to get the db connection credentials of Baserow. Put that into Metabase connection as described in https://www.metabase.com/docs/latest/administration-guide/01-managing-databases.html

    1 Reply Last reply
    3
  • J Offline
    J Offline
    JLX89
    replied to alex-a-soto on last edited by JLX89
    #3

    @alex-a-soto Building on what @girish mentioned, I've actually already done this. I logged into my Cloudron Server via SSH and ran the following:

    docker inspect {BASEROW_APP_ID} | grep CLOUDRON_POSTGRESQL
    

    Note: Change {BASEROW_APP_ID} to the ID of your app

    Metabase Settings > Databases >

    • Database type: PostgreSQL
    • Display Name: Baserow
    • Host: postgresql
    • Port: 5432
    • Database Name: (Output from docker command)
    • Database Username: (Output from docker command)
    • Database Password: (Output from docker command)
    • Schemas: All
    • Save Changes

    Working between Baserow and Metabase, it's pretty cool you can embed live data (Charts, Graphs) into other applications to give a visual view on data!

    1 Reply Last reply
    3
  • ? Offline
    ? Offline
    A Former User
    wrote on last edited by
    #4

    Hi @JLX89

    thanks for your insights.
    I used the method you described but it seems that Metabase scans the database of Baserow wrong. Instead of the tables/databases with my real data in Baserow, only the core database of Baserow syncs to Metabase so now there's like a couple of hundred tables from Baserows backend in Metabase.

    Did you maybe experience similar issues when setting up the connection between these two apps?

    Thanks,
    Simon

    1 Reply Last reply
    0
  • timconsidineT Offline
    timconsidineT Offline
    timconsidine App Dev
    replied to alex-a-soto on last edited by
    #5

    @alex-a-soto said in Metabase and Baserow:

    I'm interested in using Metabase and Baserow together.

    Just curious (aka learning) - is this more of a preference, or is there a specific advantage ?

    1 Reply Last reply
    0

  • Login

  • Don't have an account? Register

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

  • Don't have an account? Register

  • Login or register to search.