Databricks explains when to use Genie Agents, Knowledge Assistant, and a Supervisor
CautiousUse8597 · reddit · 2026-07-23
A detailed Databricks explainer compares Genie Agents and Knowledge Assistant and shows how to combine them.
What each tool does
- Genie Agent: natural-language-to-SQL over Unity Catalog tables. You can attach up to 30 tables or views, add example queries, joins, metric expressions, and instructions. It runs queries on SQL warehouses and returns tables plus charts.
- Knowledge Assistant: a document chatbot with citations, built on Databricks’ Instructed Retriever. It can ingest files from UC Volumes, UC tables with file content, or an AI Search index.
Important operational details
- Genie’s “knowledge store” is not a document KB; it stores curated semantic metadata such as descriptions, joins, and metric definitions.
- Knowledge Assistant ingestion has hard limits: files over 100 MB are skipped, PDFs/DOCs/PPTs over 500 pages are skipped, filenames starting with or . are ignored, and changed files require a manual sync.
- Initial builds can take hours.
Recommended architecture
The author recommends a Supervisor Agent over both systems. It can route requests to the Genie Agent and the Knowledge Assistant, hold up to 50 subagents, and also work with UC functions, MCP servers, dashboards, AI Search indexes, and custom Databricks Apps.
Gotchas
- Subagent descriptions matter a lot.
- Citations are not unified: SQL provenance and document citations both need to be preserved.
- Permissions cascade through the supervisor and underlying objects.
More from coding & agent
- Hermes reply shares the tldraw skill docs for the offline canvas editor — NousResearch · 2026-07-23
- Hermes adds an optional tldraw offline skill that can edit live canvases and embed scripts — NousResearch · 2026-07-23
- Channels beta bundles context, files, schedules, and approvals for AI agents — testingcatalog · 2026-07-23
- Claude Cowork analyzes 320 podcast episodes and adds persistent knowledge bases — ahuja_priyank · 2026-07-23
- Guide shows how to run OSWorld inside Daytona Windows sandboxes — dhruv2038 · 2026-07-23
- Codex’s picture-in-picture mode gets called “wild” in a quick reaction post — NielsRogge · 2026-07-23