Breyta

AI_SUMMARIZE (Transact-SQL)

Applies to: SQL analytics endpoint in Microsoft Fabric and Warehouse in Microsoft Fabric

AI_SUMMARIZE creates a concise summary of the input text.

Note

  • AI_SUMMARIZE is in preview.
  • AI_SUMMARIZE is available only in SQL analytics endpoint and Warehouse in Microsoft Fabric.

Syntax

Transact-SQL syntax conventions

AI_SUMMARIZE ( text )

Arguments

text

An expression of a character type, for example nvarchar, varchar, nchar, or char.

Return types

Returns nvarchar containing the generated summary.

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. Summarize a sentence

SELECT ai_summarize('The hotel was clean and staff were friendly.') AS summary;

Expected result: Clean hotel, friendly staff.

B. Summarize review text in a table

SELECT review_id,
       ai_summarize(review_text) AS review_summary
FROM dbo.hotel_reviews;