surfaceclassificationquality_llm
Classificationscalar · returns double

QUALITY_LLM

LLM-backed data quality assessment (0.0-1.0)

Per-row — runs once for each row.

classificationllmllm-escape-hatchtext

Syntax

QUALITY_LLM({{ value }})
QUALITY_LLM({{ value }}, '{{ expected_type }}')

Arguments

nametypedescription
valueVARCHAR
expected_type(optional)VARCHARExpected type hint

About

LLM-backed escape hatch for QUALITY. Use when the deterministic scorer in QUALITY can't judge the value — typically: - Free-form prose that needs subjective quality judgment - Domain-specific quality criteria (marketing copy, technical docs) - Policy compliance or tone grading For structured data (emails, phones, addresses, dates, names), prefer QUALITY — the deterministic scorer is instant and type-aware.

Examples

LLM escape hatch: perfect email

SELECT
  quality_llm ('john.smith@gmail.com')

LLM escape hatch: empty value

SELECT
  quality_llm ('')

Nearby rabbit holes

same domain
Climb back to The Looking Glass