cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Generative AI
Explore discussions on generative artificial intelligence techniques and applications within the Databricks Community. Share ideas, challenges, and breakthroughs in this cutting-edge field.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

What Is โ€“ Agent mode in Genie? (Quick answers vs investigations)

Valeria_Koz_DBX
Databricks Employee
Databricks Employee

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?

2 REPLIES 2

vuj01
New Contributor II

If we start with a chat mode and need to use agent mode in context or continuation to the previous question, is it necessary to start a new chat with agent mode?

Valeria_Koz_DBX
Databricks Employee
Databricks Employee

Good question, @vuj01 
As far as I can tell, unfortunately, yes, you'll need to start a new chat. Each Genie conversation is set as either chat or agent mode when it starts. Context also stays inside one chat, so the new one won't remember the earlier thread.

A trick/workaround here:
1. Start a New chat and turn on Agent mode before sending the first message.
2. Paste in the context from the earlier chat:
the original question, key filters and definitions, and ideally the SQL Genie generated, so the agent starts from the same logic.

If you mainly picked chat mode for speed, it's worth trying Flash (Beta). It's an option you turn on when you start an Agent mode conversation, and it answers faster while keeping the agent features. Like Agent mode, it can only be switched on before the first message.

---

I left out the internal points about chat mode being phased out. "As far as I can tell" covers the fact that the docs don't say outright you can't switch an existing thread in the UI. If you test it first and it confirms, you could drop that hedge.