Extract (subject, predicate, object) knowledge graph triples from text
Per-row — runs once for each row.
TRIPLES({{ text }})TRIPLES({{ text }}, '{{ focus }}'){{ text }} TRIPLES| name | type | description |
|---|---|---|
| text | VARCHAR | — |
| focus(optional) | VARCHAR | Focus area: 'people', 'organizations', 'decisions', 'events', 'all' |
Extracts employment and reporting relationships
SELECT
triples (
'John Smith works at Acme Corp as a software engineer. He reports to Jane Doe.'
)Extracts event information
SELECT
triples (
'The meeting on Tuesday was cancelled. Bob will reschedule for next week.'
)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 (subject, predicate, object) knowledge graph triples from text
Per-row — runs once for each row.
TRIPLES({{ text }})TRIPLES({{ text }}, '{{ focus }}'){{ text }} TRIPLES| name | type | description |
|---|---|---|
| text | VARCHAR | — |
| focus(optional) | VARCHAR | Focus area: 'people', 'organizations', 'decisions', 'events', 'all' |
Extracts employment and reporting relationships
SELECT
triples (
'John Smith works at Acme Corp as a software engineer. He reports to Jane Doe.'
)Extracts event information
SELECT
triples (
'The meeting on Tuesday was cancelled. Bob will reschedule for next week.'
)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