Concept card

Databricks Genie — text-to-SQL agent

As of 2026-07-24T14:00:00Z

Edited by Cédric-Olivier Mâry, sole editor and publication director — 27 years in the SAP ecosystem. How these pages are produced, and where automation is used.

What is Databricks Genie — text-to-SQL agent?

Genie's governance guarantee is that Unity Catalog enforces the user's own data permissions at query time — there is no privilege escalation through the natural-language interface.

What it is

Databricks Genie is a governed natural-language query agent built into Databricks SQL. A business user types a question in plain English and receives a SQL-generated answer against Delta Lake tables, without writing SQL themselves. It is deliberately not a general-purpose chat interface: every Genie deployment is scoped to a Genie Space — an explicit configuration of the Delta tables in play, a semantic layer of business-term definitions, curated sample questions, and trusted SQL snippets that the data team authors and maintains. The large language model behind Genie draws on this curated context rather than open-ended reasoning about arbitrary tables, which is what keeps its answers close to the ground truth the data team has actually validated.

Why it matters: for organisations that have already invested in bringing SAP data into Databricks — typically through SAP Business Data Cloud's Delta Sharing integration — Genie is the fastest way to convert that replicated data into genuine self-service for non-technical stakeholders. A finance or supply-chain analyst who cannot write a join across three fact tables can still ask what margin looked like by product line in Germany last quarter and get a defensible answer, with the underlying SQL exposed via a View SQL button for anyone who wants to audit exactly what ran. This closes a long-standing gap in enterprise BI: dashboards answer the ten questions someone anticipated, while Genie answers the eleventh question nobody built a report for.

Why it matters

Genie only works within its configured 'Genie Space' — a fixed set of Delta tables, business-term definitions, and trusted SQL snippets, not open internet knowledge.
It's the natural fit for repetitive, well-documented reporting: finance spend by cost centre, sales pipeline by region, supply-chain inventory by plant.
When SAP data reaches Databricks via BDC Delta Sharing, a Genie Space over those tables lets finance or supply-chain teams self-serve without SAP licences or SQL skills.

Key points

Databricks Genie — text-to-SQL agent is mastered only when it changes a named buyer decision.
Start with the semantic contract and control model before demonstrating the tool.
Use current SAP, analyst, study, KG, and news signals as evidence, not decoration.
Separate verified facts from directional trends and modeled assumptions.
Define owner, metric, threshold, support path, and rollback before scaling.
For AI use cases, measure reliability, cost, latency, safety, and human validation.
Leave a reusable operating asset: memo, checklist, control table, and exception log.
A premium answer is short, trade-off explicit, and defensible in a steering committee.

Terms used on this page

Decision owner: The accountable person who accepts the trade-off and funds the next action.
Semantic contract: The shared definition of business terms, metrics, entities, and access rules used by tools and teams.
Control plane: The layer that applies policy, access, lineage, monitoring, and escalation across the operating model.
Evidence grade: A label that separates verified fact, directional signal, modeled assumption, and field observation.
Adoption metric: The measurable behavior proving that the concept changed actual work after go-live.
Agent reliability: The consistency, cost, safety, and policy compliance of an agent across repeated runs.

Sources

Full card available to members. What the full card adds: the full decision framework · the SAP vs Snowflake / Databricks / Fabric comparison · the common pitfalls and their fix · the cheat sheet · the architecture schemas · the code blocks · the facts worth quoting.

Open in the app →