Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL analytics endpoint in Microsoft Fabric and Warehouse in Microsoft Fabric
The AI_CLASSIFY function classifies input text into one of the labels you provide.
Note
AI_CLASSIFYis in preview.AI_CLASSIFYis available only in SQL analytics endpoint and Warehouse in Microsoft Fabric.
Syntax
Transact-SQL syntax conventions
AI_CLASSIFY ( text, class1, class2 [ , ...n ] )
Arguments
text
An expression of a character type, for example nvarchar, varchar, nchar, or char.
class1, class2, ...n
One or more candidate class labels, provided as string literals or string expressions.
Return types
Returns nvarchar containing the selected class label.
Remarks
AI functions return NULL if the AI model can't process the text. Common reasons include:
- Responsible AI rules block inappropriate content in the input text.
- Input text exceeds token limits. The current model supports up to 15 KB of text.
Examples
A. Classify text with custom labels
SELECT ai_classify('Room was dirty', 'service', 'dirt', 'food') AS classification;
Expected result: dirt
B. Classify rows in a table
SELECT review_id,
ai_classify(review_text, 'service', 'dirt', 'food', 'other') AS category
FROM dbo.hotel_reviews;