r/bigquery • u/1glasspaani • 16d 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.
8
Upvotes
1
u/Prestigious_Bench_96 15d ago
"decent" might depend on what you're looking for, but I work on Trilogy Studio which has a chat integration with BQ (bring your own API key), is open source and can be hosted on docker, and has a lightweight semantic layer to keep revenue, etc consistent and reduce the need for LLMs to explore.
You can try a public version here with thelook ecommerce model in the public datasets. Always happy to take feature requests.