LLM-backed year extraction (escape hatch for CLEAN_YEAR)
Per-row — runs once for each row.
CLEAN_YEAR_LLM({{ text }})| name | type | description |
|---|---|---|
| text | VARCHAR | — |
Spelled-out year extracted
SELECT
clean_year_llm ('nineteen eighty-four')Fiscal year extracted
SELECT
clean_year_llm ('FY2023')Remove or mask personally identifiable information from text
Type-cast messy real-world values that trip up standard CAST
Return the canonical/official form of a value (auto-detects entity type)
Extracts 4-digit year from messy text, returns -1 if undetermined
Pick the best non-null value from a group (quality-aware COALESCE)
Fill in missing parts of a partial value using context
LLM-backed year extraction (escape hatch for CLEAN_YEAR)
Per-row — runs once for each row.
CLEAN_YEAR_LLM({{ text }})| name | type | description |
|---|---|---|
| text | VARCHAR | — |
Spelled-out year extracted
SELECT
clean_year_llm ('nineteen eighty-four')Fiscal year extracted
SELECT
clean_year_llm ('FY2023')Remove or mask personally identifiable information from text
Type-cast messy real-world values that trip up standard CAST
Return the canonical/official form of a value (auto-detects entity type)
Extracts 4-digit year from messy text, returns -1 if undetermined
Pick the best non-null value from a group (quality-aware COALESCE)
Fill in missing parts of a partial value using context