surfaceclassificationlanguage_llm
Classificationdimension · returns varchar

LANGUAGE_LLM

LLM-backed language detection (escape hatch for LANGUAGE)

Per-row classifier — stable across GROUP BY.

classificationllmllm-escape-hatchtext

Syntax

LANGUAGE_LLM({{ text }})
{{ text }} BY LANGUAGE_LLM

Arguments

nametypedescription
textVARCHAR

About

LLM-backed escape hatch for language detection. Use when LANGUAGE (xlm-roberta-lid) doesn't cover a language — the model handles 20+ common languages but an LLM can handle many more including rare and dialectal forms. For the 20 languages xlm-roberta-lid knows (en, es, fr, de, it, pt, nl, ru, zh, ja, ko, ar, hi, vi, tr, th, pl, sw, ur, bg, el), prefer LANGUAGE — it's much faster and highly accurate.

Examples

LLM escape hatch detects English

SELECT
  language_llm ('Hello, how are you today?')

Nearby rabbit holes

same domain
Climb back to The Looking Glass