Using Metabase with Bubble data

Need help Database
1

Hello, has anyone connected Metabase BI with their Bubble data? I’m wanting to do some data analytics but can’t fing how to connect.

Many thanks!

2

What did you try? API Connector? Screenshot please?

3

API connector doesn’t seem to be an option with Metabase. Here’s what they have from what I can see:

image
image1920×1080 157 KB

4

API Connector is something you add in Bubble in plugins section

5

Sorry, I don’t understand…Bubble API connector is setup, what I want to do now is read Bubble data in Metabase ( so I can produce dashboards etc) but I can’t see how to do that.

6

Ha Sorry. I don’t know if this is possible in this case. Bubble allow DB access using API.
Youcould maybe consider using your own DB solution (For example, Bubble have an SQL connector… so you could use MySQL in Bubble and fetch data to this DB from Metabase)

7

I did a Metabase setup with a Bubble app few days ago:

  1. Setup events you want to monitor (trigger db saved in an Event dedicated tab) in Bubble
  2. n8n as an ETL to call the Bubble API every day to get new data from the Event table
  3. Setup a BigQuery DB to store the events
  4. Connect the BigQuery DB to Metabase

It works perfectly fine and it’s very useful to track product analytics

8

Thank you for the suggestion. This requires additional paid software though, which is what I am looking to avoid (and the reason for ideally wanting to use Metabase).

9

I’m using Metabase here, but you need to send your events to a database that’s connected to Metabase. Metabase isn’t a database—it’s a data visualization and dashboarding tool that requires a database connection to work.

→ n8n is free if you self-host it, just like Metabase.

→ BigQuery is free for up to 10GB of data processed per month, which can represent millions of rows depending on row size. After that, the cost is still very affordable—just a few dollars per month for tens of millions of rows.

10

If you’re on Bubble’s dedicated plan, it might also work by connecting directly to Bubble’s database via SQL.

11

I’m on the starter plan. I managed to connect Power BI using Bubble’s API and was hoping I could do something similar with Metabase.