Convert a value to a target unit via pint
Per-row — runs once for each row.
NORMALIZE_UNIT({{ value }}, '{{ target_unit }}')| name | type | description |
|---|---|---|
| value | VARCHAR | — |
| target_unit | VARCHAR | Target unit: kg, lb, m, ft, cm, ml, l, oz, celsius, etc. |
5 kg approx 11.02 lb
SELECT
normalize_unit ('5 kg', 'lb')100F approx 37.78 C
SELECT
normalize_unit ('100 F', 'celsius')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)
Convert a value to a target unit via pint
Per-row — runs once for each row.
NORMALIZE_UNIT({{ value }}, '{{ target_unit }}')| name | type | description |
|---|---|---|
| value | VARCHAR | — |
| target_unit | VARCHAR | Target unit: kg, lb, m, ft, cm, ml, l, oz, celsius, etc. |
5 kg approx 11.02 lb
SELECT
normalize_unit ('5 kg', 'lb')100F approx 37.78 C
SELECT
normalize_unit ('100 F', 'celsius')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)