Data Agent: Support for SQL Views + Functions
Data Science · Public preview · Planned
Description
SQL Views and Functions support in Data Agent enables the system to work with richer, production-grade SQL entities by incorporating views and reusable logic directly into query generation. This dramatically improves data accessibility, reduces complexity, and boosts NL2SQL accuracy by allowing Data Agent to rely on curated schemas, simplified naming, and pre-defined joins rather than raw underlying tables. The result is more reliable, performant, and business-friendly analytics experiences for creators and downstream users
Change History
-
2026-02-09
Release Date 2026-02-28 -> 2026-03-06 -
2026-02-09
Release Date 2025-09-30 -> 2026-02-28Feature Description Data Agent only supports T-SQL Tables through the SQL Analytics Endpointbut production SQL systems heavily rely on Views and Functions to perform complex operations and scope data to a consumer's specific use case. Data Agent can leverage these Views and Functions to generate more complex queries. -> SQL Views and Functions support in Data Agent enables the system to work with richerproduction-grade SQL entities by incorporating views and reusable logic directly into query generation. This dramatically improves data accessibilityreduces complexityand boosts NL2SQL accuracy by allowing Data Agent to rely on curated schemassimplified namingand pre-defined joins rather than raw underlying tables. The result is more reliableperformantand business-friendly analytics experiences for creators and downstream users -
2025-08-28
Roadmap Item Added
Workload: Data Science