Auto-fix common data-quality issues (typos, casing, formats)
Per-row — runs once for each row.
FIX({{ value }}, '{{ type_hint }}')FIX({{ value }})| name | type | description |
|---|---|---|
| value | VARCHAR | — |
| type_hint(optional) | VARCHAR | Type hint: email, phone, address, name, date, url, etc. |
Email typo fixed
SELECT
fix ('john@gmial.com', 'email')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)
Auto-fix common data-quality issues (typos, casing, formats)
Per-row — runs once for each row.
FIX({{ value }}, '{{ type_hint }}')FIX({{ value }})| name | type | description |
|---|---|---|
| value | VARCHAR | — |
| type_hint(optional) | VARCHAR | Type hint: email, phone, address, name, date, url, etc. |
Email typo fixed
SELECT
fix ('john@gmial.com', 'email')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)