Extract (subject, predicate, object, evidence) knowledge graph triples with source context
Per-row — runs once for each row.
RICH_TRIPLES({{ text }})RICH_TRIPLES({{ text }}, '{{ focus }}'){{ text }} RICH_TRIPLES| name | type | description |
|---|---|---|
| text | VARCHAR | — |
| focus(optional) | VARCHAR | Focus area: 'people', 'organizations', 'decisions', 'events', 'all' |
Extracts triples with supporting evidence
SELECT
rich_triples (
'John Smith works at Acme Corp as a software engineer. He reports to Jane Doe.'
)Extracts decisions with context
SELECT
rich_triples (
'The Q3 budget of $500K was approved by Mike on Tuesday.'
)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, evidence) knowledge graph triples with source context
Per-row — runs once for each row.
RICH_TRIPLES({{ text }})RICH_TRIPLES({{ text }}, '{{ focus }}'){{ text }} RICH_TRIPLES| name | type | description |
|---|---|---|
| text | VARCHAR | — |
| focus(optional) | VARCHAR | Focus area: 'people', 'organizations', 'decisions', 'events', 'all' |
Extracts triples with supporting evidence
SELECT
rich_triples (
'John Smith works at Acme Corp as a software engineer. He reports to Jane Doe.'
)Extracts decisions with context
SELECT
rich_triples (
'The Q3 budget of $500K was approved by Mike on Tuesday.'
)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