Translates business questions into validated SQL against the semantic model.
Activation complexity
Medium
Time to activate
10-14 days
Volume share
35-45% of role volume
Impact range
Sub-minute on routine; under an hour on multi-source
Inherited pricing
€0.80 – €3.50 per query or report handled
This capability shares the Data Analyst's metered unit. A query or report handled is counted once at the role level regardless of which capability handled it. Adding this capability to an active deployment does not change the per-action price.
What this capability handles
NL-to-SQL reads the business question, resolves metrics through the semantic layer, drafts SQL against the governed warehouse, validates with a sanity-check pass, and returns the answer with lineage — with analyst review on novel metrics and sensitive breakdowns.
Workflow summary
Reads question, resolves metric, drafts SQL, validates, returns with lineage.
Stages
Decision logic
Uses semantic-model matching and metric-dictionary rules to draft validated SQL and flag novel or ambiguous requests.
Systems and data
{warehouse,"semantic layer","BI tool",messaging}
{"metric dictionary","semantic model","prior queries","schema catalog"}
Exceptions & human handoff
Novel metrics, cross-domain joins, or PII-adjacent cuts route to the analyst for review.
Novel metric, cross-domain ambiguity, or PII-adjacent cut.
Readiness
Semantic model documented, metric dictionary approved, warehouse access wired.
Owner on client side · Head of Data
Impact contribution
35-45% of role impact is ad-hoc question throughput with query-lineage fidelity.
Primary KPI · Query turnaround · Sub-minute on routine; under an hour on multi-source
Capability-specific integrations
Beyond the Data Analyst's base stack, this capability plugs into:
The chat opens with Data Analyst and NL-to-SQL pre-selected. You can add other capabilities during the conversation.