LLM-backed currency parsing with approximate rates (escape hatch for NORMALIZE_CURRENCY)
Per-row — runs once for each row.
NORMALIZE_CURRENCY_LLM({{ value }})NORMALIZE_CURRENCY_LLM({{ value }}, '{{ target_currency }}')NORMALIZE_CURRENCY_LLM({{ value }}, '{{ target_currency }}', '{{ reference_date }}')| name | type | description |
|---|---|---|
| value | VARCHAR | — |
| target_currency(optional) | VARCHAR | — |
| reference_date(optional) | VARCHAR | — |
LLM escape hatch converts currency
SELECT
normalize_currency_llm ('100 dollars', 'EUR')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
LLM-backed year extraction (escape hatch for CLEAN_YEAR)
Pick the best non-null value from a group (quality-aware COALESCE)
LLM-backed currency parsing with approximate rates (escape hatch for NORMALIZE_CURRENCY)
Per-row — runs once for each row.
NORMALIZE_CURRENCY_LLM({{ value }})NORMALIZE_CURRENCY_LLM({{ value }}, '{{ target_currency }}')NORMALIZE_CURRENCY_LLM({{ value }}, '{{ target_currency }}', '{{ reference_date }}')| name | type | description |
|---|---|---|
| value | VARCHAR | — |
| target_currency(optional) | VARCHAR | — |
| reference_date(optional) | VARCHAR | — |
LLM escape hatch converts currency
SELECT
normalize_currency_llm ('100 dollars', 'EUR')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
LLM-backed year extraction (escape hatch for CLEAN_YEAR)
Pick the best non-null value from a group (quality-aware COALESCE)