AI Functions in DW
Data Warehouse · Public preview · Shipped
Description
AI functions natively available in T-SQL allow you to seamlessly integrate powerful language capabilities into your queries. You can analyze sentiment, classify text into predefined labels, extract contextual insights, translate between languages, correct grammar, or run flexible, prompt-based instructions--all directly from T-SQL. This feature enables intelligent data processing and enrichment without leaving the database environment.For example:<br/>```SELECT ai_analyze_sentiment(text), ai_classify(text, 'hardware', 'software') FROM reviews```
Change History
-
2026-03-26
Release Date 2026-03-31 -> 2026-03-23Release Status Planned -> Shipped -
2026-01-14
Release Date 2026-03-20 -> 2026-03-31 -
2025-10-14
Feature Description AI functions that can be invoked directly through T-SQLfor example:```sqlSELECT ai_analyze_sentiment(text)ai_classify(text'hardware''software') FROM reviews``` -> AI functions natively available in T-SQL allow you to seamlessly integrate powerful language capabilities into your queries. You can analyze sentimentclassify text into predefined labelsextract contextual insightstranslate between languagescorrect grammaror run flexibleprompt-based instructions--all directly from T-SQL. This feature enables intelligent data processing and enrichment without leaving the database environment.For example:<br/>```SELECT ai_analyze_sentiment(text)ai_classify(text'hardware''software') FROM reviews``` -
2025-10-13
Release Date 2025-09-29 -> 2026-03-20Feature Description AI functions that can be invoked directly through T-SQLfor example:SELECT ai_translate(comment'en') as commentEnglish FROM table -> AI functions that can be invoked directly through T-SQLfor example:```sqlSELECT ai_analyze_sentiment(text)ai_classify(text'hardware''software') FROM reviews``` -
2025-10-10
Roadmap Item Added
Workload: Data Warehouse