La Caisse (CDPQ) · 2026 · In production
Hybrid conversational agent over a Databricks lakehouse
- Problem
- Investment teams relied on manual SQL work to answer recurring questions about financial data.
- Built
- A deterministic SQL engine for the known question families, with an automatic Databricks Genie fallback for the rest. Every answer is traceable to its query. Evaluated in MLflow with deterministic scorers and LLM judges.
- Result
- About 80% of queries answered in about 1 s, against 30 to 45 s before.
Databricks · LangGraph · MLflow · SQL · Azure DevOps
Learn more