surface↓transformation↓smart_translate
Transformationscalar · returns varchar

SMART_TRANSLATE

Translate text between languages (auto-detects source language)

Per-row — runs once for each row.

transformationllmtext

Syntax

SMART_TRANSLATE({{ text }}, '{{ target_language }}')
SMART_TRANSLATE({{ text }}, '{{ target_language }}', '{{ source_language }}')
{{ text }} TRANSLATED TO '{{ target_language }}'

Arguments

nametypedescription
textVARCHAR—
target_languageVARCHARTarget language code: en, es, fr, de, zh, ja, etc.
source_language(optional)VARCHARSource language code or 'auto' for detection

About

Translate text from one language to another. Auto-detects the source language if you don't specify one. Useful for normalizing multilingual feedback, product catalogs, support tickets, or scraped content before downstream analysis. Works across the range of languages the underlying model supports, including right-to-left scripts and non-Latin alphabets.

Examples

English to Spanish

SELECT
  smart_translate ('Hello world', 'es')

Nearby rabbit holes

same domain
scalar

FORMALIZE

Rewrite informal/messy text into a professional form

transformationllmtext
pipeline

SPEAK

Read query results or analysis aloud via TTS

transformationllmpipeline-composabletext
scalar

TRANSCRIBE

Speech-to-text via Whisper large-v3-turbo

transformationllmtext
Climb back to The Looking Glass