Databricks Genie-Enhanced Agentic System Architecture

1. Interaction & Orchestration
(Mosaic AI)

💻
User
Interface

🧠

Mosaic AI
Supervisor Agent
(Orchestrator &
State Manager)


Routes queries,
maintains conversation
state

2. Cognitive Processing Layer
(Custom Logic)

⚙️
Intent Understanding
& Guardrails
(LLM Endpoint)

Complexity
Gate: Simple vs.
Complex?

📄
JSON Feedback
Request
(Clarification Payload)

👤
User
Clarification
(Feedback Loop)

3. Execution Layer
(Databricks Genie Space)

🧞
Databricks Genie Space
(NL-to-SQL Engine)

🕯️
Genie API
Endpoint

🗄️
Unity Catalog
Metadata
(Schemas,
Comments,
Relationships)

📜
Trusted Assets
/ SQL Templates
(Gold Standard
Queries)

4. Verification & Output Layer
(Final Agent)

🔍
Verification Agent
(Mosaic AI Auditor)

📄 Syntactic Check
(vs. Unity Catalog Schema)

👤 Semantic Check
(vs. Original Question)

📊

Final Data
Visualization
& Validated
SQL Output