Breyta

AI_TRANSLATE (Transact-SQL)

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

AI_TRANSLATE translates input text into a target language.

Note

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

Syntax

Transact-SQL syntax conventions

AI_TRANSLATE ( text, lang_code )

Arguments

text

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

lang_code

Language code for the translation target.

Supported values: de, en, fr, it, es, el, pl, sv, fi, cs.

Return types

Returns nvarchar(max) with translated text.

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. Translate to German

SELECT ai_translate('The hotel was great', 'de') AS translation_de;

Expected result: Das Hotel war großartig.

B. Translate review text into multiple languages

SELECT review_id,
       ai_translate(review_text, 'de') AS review_de,
       ai_translate(review_text, 'fr') AS review_fr,
       ai_translate(review_text, 'es') AS review_es
FROM dbo.hotel_reviews;

Related content

  • Last updated on