Metabase and Baserow
-
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 -
@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 -
JLX89replied to alex-a-soto on Jun 2, 2022, 3:25 PM last edited by JLX89 Jun 2, 2022, 3:28 PM
@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!
-
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 -
@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 ?