Classify single text into one of the provided topics (zero-shot NLI)
Per-row — runs once for each row.
CLASSIFY_SINGLE({{ text }}, '{{ topics }}')| name | type | description |
|---|---|---|
| text | VARCHAR | — |
| topics | JSON | — |
Function: Positive sentiment classified
SELECT
semantic_classify (
'I love this product!',
'positive,negative,neutral'
)Function: Negative sentiment classified
SELECT
semantic_classify (
'This is terrible, worst purchase ever',
'positive,negative,neutral'
)Function: Neutral statement classified
SELECT
semantic_classify (
'The item arrived on time',
'positive,negative,neutral'
)Function: Support request classified
SELECT
semantic_classify (
'Need help with my broken laptop',
'sales,support,billing,general'
)Function: Upgrade request (sales, billing, or support)
SELECT
semantic_classify (
'I want to upgrade my subscription',
'sales,support,billing,general'
)Alias classify(): Business news classified
SELECT
classify (
'Stock market reaches all-time high',
'sports,politics,business,technology'
)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)
Classify single text into one of the provided topics (zero-shot NLI)
Per-row — runs once for each row.
CLASSIFY_SINGLE({{ text }}, '{{ topics }}')| name | type | description |
|---|---|---|
| text | VARCHAR | — |
| topics | JSON | — |
Function: Positive sentiment classified
SELECT
semantic_classify (
'I love this product!',
'positive,negative,neutral'
)Function: Negative sentiment classified
SELECT
semantic_classify (
'This is terrible, worst purchase ever',
'positive,negative,neutral'
)Function: Neutral statement classified
SELECT
semantic_classify (
'The item arrived on time',
'positive,negative,neutral'
)Function: Support request classified
SELECT
semantic_classify (
'Need help with my broken laptop',
'sales,support,billing,general'
)Function: Upgrade request (sales, billing, or support)
SELECT
semantic_classify (
'I want to upgrade my subscription',
'sales,support,billing,general'
)Alias classify(): Business news classified
SELECT
classify (
'Stock market reaches all-time high',
'sports,politics,business,technology'
)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)