Hello, I've just downloaded Metabase and would like to connect it to my bubble.io database but can't find any information. Does anyone know how to do this?
Many thanks!
Hi there,
bubble.io only allows obtaining data through its Data HTTP API, so you can't directly connect it to Metabase. However, you can set up an ETL tool to copy data from that API into a SQL database and connect Metabase to it.
I managed to do it by using Airbyte to periodically copy data from Bubble to a Supabase DB (Postgres). You can use the Connection Builder to read from Bubble, here's an example YAML of my setup. Then you connect it to your destination Supabase (make sure to use pool_mode=session).
That's what I got working at least, hope that it helps!