LLM-backed single-text classification (escape hatch for CLASSIFY_SINGLE)
Per-row — runs once for each row.
CLASSIFY_SINGLE_LLM({{ text }}, '{{ topics }}')semantic_classify_llm({{ text }}, '{{ topics }}')| name | type | description |
|---|---|---|
| text | VARCHAR | — |
| topics | JSON | — |
LLM escape hatch: positive sentiment
SELECT
semantic_classify_llm (
'I love this product!',
'positive,negative,neutral'
)LLM escape hatch: negative sentiment
SELECT
semantic_classify_llm (
'This is terrible, worst purchase ever',
'positive,negative,neutral'
)Identify target audience via zero-shot NLI
LLM-backed audience identification (escape hatch for AUDIENCE)
Assess authenticity of content via zero-shot NLI
LLM-backed authenticity assessment (escape hatch for AUTHENTICITY)
Classify text into user-specified buckets via zero-shot NLI
LLM-backed bucketing (escape hatch for BUCKET)
LLM-backed single-text classification (escape hatch for CLASSIFY_SINGLE)
Per-row — runs once for each row.
CLASSIFY_SINGLE_LLM({{ text }}, '{{ topics }}')semantic_classify_llm({{ text }}, '{{ topics }}')| name | type | description |
|---|---|---|
| text | VARCHAR | — |
| topics | JSON | — |
LLM escape hatch: positive sentiment
SELECT
semantic_classify_llm (
'I love this product!',
'positive,negative,neutral'
)LLM escape hatch: negative sentiment
SELECT
semantic_classify_llm (
'This is terrible, worst purchase ever',
'positive,negative,neutral'
)Identify target audience via zero-shot NLI
LLM-backed audience identification (escape hatch for AUDIENCE)
Assess authenticity of content via zero-shot NLI
LLM-backed authenticity assessment (escape hatch for AUTHENTICITY)
Classify text into user-specified buckets via zero-shot NLI
LLM-backed bucketing (escape hatch for BUCKET)