Extract multiple distinct values from a compound/messy field
Per-row — runs once for each row.
SMART_UNPACK({{ value }})SMART_UNPACK({{ value }}, '{{ extract }}')| name | type | description |
|---|---|---|
| value | VARCHAR | — |
| extract(optional) | VARCHAR | What to extract: 'email and phone', 'name and title', 'auto' |
Email and phone unpacked
SELECT
smart_unpack ('john@email.com, 555-1234')Crawl a website and extract structured data from each page (via Firecrawl)
Extract specific information from unstructured text (zero-shot NER)
LLM-backed extraction (escape hatch for EXTRACTS)
Extract structured fields from text per a user-supplied schema
Merge multiple timelines into unified chronological sequence
Extract information from text using natural-language instructions
Extract multiple distinct values from a compound/messy field
Per-row — runs once for each row.
SMART_UNPACK({{ value }})SMART_UNPACK({{ value }}, '{{ extract }}')| name | type | description |
|---|---|---|
| value | VARCHAR | — |
| extract(optional) | VARCHAR | What to extract: 'email and phone', 'name and title', 'auto' |
Email and phone unpacked
SELECT
smart_unpack ('john@email.com, 555-1234')Crawl a website and extract structured data from each page (via Firecrawl)
Extract specific information from unstructured text (zero-shot NER)
LLM-backed extraction (escape hatch for EXTRACTS)
Extract structured fields from text per a user-supplied schema
Merge multiple timelines into unified chronological sequence
Extract information from text using natural-language instructions