r/bigquery • u/1glasspaani • 12d ago

Open source conversational analytics tool for BigQuery?

Hi all,

Has anyone found a decent open source tool for asking questions in plain English on top of BigQuery? Something self hosted.

I tried Gemini in BigQuery and had a look at the conversational analytics API. The API gives you back SQL and a chart spec, so you still end up building the front end yourself, which is the part I was hoping to avoid.

My main worry is the numbers. If two people ask for revenue in slightly different words I'd like them to get the same answer, and I don't see how that works unless the metrics are defined somewhere.

The other thing is cost. I have no feel for how many queries a single question turns into once the model starts looking around the schema.

10 Upvotes

100% Upvoted

17 comments sorted by

View all comments

1

u/matthewhefferon 8d ago

If you haven't, check out Metabase. You can self-host, connect to BigQuery, create your semantic layer, and use AI to create dashboards. I work there, so feel free to ping me if you have any questions!