Extract information from text using natural-language instructions
Per-row — runs once for each row.
PARSE({{ text }}, {{ instruction }}){{ text }} PARSE {{ instruction }}| name | type | description |
|---|---|---|
| text | VARCHAR | The text to parse |
| instruction | VARCHAR | What to extract (natural language) |
Date extracted from text
SELECT
parse (
'Meeting scheduled for March 15, 2024 at 2pm',
'the date'
)Email extracted from text
SELECT
parse (
'Contact John Smith at john@acme.com for details',
'email address'
)Amount extracted from text
SELECT
parse ('The project budget is $50,000', 'budget amount')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
Parse, validate, or transform patterned strings using plain-English instructions
Extract information from text using natural-language instructions
Per-row — runs once for each row.
PARSE({{ text }}, {{ instruction }}){{ text }} PARSE {{ instruction }}| name | type | description |
|---|---|---|
| text | VARCHAR | The text to parse |
| instruction | VARCHAR | What to extract (natural language) |
Date extracted from text
SELECT
parse (
'Meeting scheduled for March 15, 2024 at 2pm',
'the date'
)Email extracted from text
SELECT
parse (
'Contact John Smith at john@acme.com for details',
'email address'
)Amount extracted from text
SELECT
parse ('The project budget is $50,000', 'budget amount')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
Parse, validate, or transform patterned strings using plain-English instructions