Split a value into components without hardcoding a delimiter
Per-row — runs once for each row.
SMART_SPLIT({{ value }})SMART_SPLIT({{ value }}, '{{ instruction }}')| name | type | description |
|---|---|---|
| value | VARCHAR | — |
| instruction | VARCHAR | Split instruction: delimiter, 'into array', 'into first and last', etc. |
Comma-separated values split correctly
SELECT
smart_split ('apple,banana,cherry', 'comma')Name split into first/last
SELECT
smart_split ('John Smith', 'into first and last')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
Split a value into components without hardcoding a delimiter
Per-row — runs once for each row.
SMART_SPLIT({{ value }})SMART_SPLIT({{ value }}, '{{ instruction }}')| name | type | description |
|---|---|---|
| value | VARCHAR | — |
| instruction | VARCHAR | Split instruction: delimiter, 'into array', 'into first and last', etc. |
Comma-separated values split correctly
SELECT
smart_split ('apple,banana,cherry', 'comma')Name split into first/last
SELECT
smart_split ('John Smith', 'into first and last')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