Hi everyone,
I’m exploring the idea of creating a chatbot within Databricks that can handle ad‑hoc business analytics queries. For example, I’d like users to be able to ask questions such as:
“How many sales did we have in 2025?”
“Which products had the most sales?”
“Who owns what?”
“Which regions performed best?”
The goal is to let business users type natural language questions and get answers directly from our data in Databricks, without needing to write SQL or Python.
My questions are:
Is this kind of chatbot doable with Databricks?
What tools or integrations (e.g., LLMs, Databricks SQL, Unity Catalog, Lakehouse AI) would be best suited for this?
Are there recommended architectures or examples for connecting a conversational interface to Databricks tables/views so it can translate natural language into queries?
How do we handle governance and security when exposing data through a chatbot?
Any guidance, references, or best practices would be greatly appreciated!
Thanks in advance.
