Imagine asking a colleague two questions on the same morning.
The first: "What was our travel spend last month?" They open a report, read off a number, and you're done in a minute. That's a lookup.
The second: "Why is our travel spend so much higher than last year?" A good colleague won't answer that with one number. They'll think of a few possible reasons, such as more trips, pricier trips or one team travelling more, check each against the data, and come back with a short write-up and the evidence. That's an investigation.
Genie, the Databricks tool that lets you ask questions about your data in plain English, can now work both ways. The second way is called Agent mode.
The two ways Genie can answer
Chat mode is the quick-answer colleague. Genie writes one query and shows you the result as a table or chart. It's best for "what", "how much" and "how many" questions.
Agent mode is the investigating colleague who asks "why". Genie plans its approach, runs several queries one after another (each informed by the last), and writes up what it found in a short report. You can follow every step and the query behind it, so you can check its reasoning instead of just trusting the conclusion.
A real-world example
A finance team I worked with kept facing the same question: "Why are we over budget this quarter?" Answering it meant an analyst pulling several reports into a spreadsheet and writing an email, which took days.
With Agent mode, a manager can ask directly. Genie breaks the overspend down by department, then by supplier, spots that most of it comes from two suppliers, and writes it up. The analyst's job shifts from building the answer to checking it.
When to use which
- Use chat mode when you know exactly what you want: a number, a list, a chart.
- Use Agent mode for "why" and "what's driving" questions. Agent mode is slower because it does more work, so it's the wrong choice for simple lookups.
One caution: an investigation is only as good as the briefing. If Genie hasn't been told how your team defines "spend" or "budget", you'll get a confident report about the wrong thing. Read the steps, not just the conclusion.
What's the first "why" question you'd hand to an investigating colleague?