LLM-only topic extraction + assignment (escape hatch for TOPICS)
Per-row classifier — stable across GROUP BY.
TOPICS_LLM({{ text }})TOPICS_LLM({{ text }}, {{ num_topics }})TOPICS_LLM({{ text }}, {{ num_topics }}, '{{ focus }}')| name | type | description |
|---|---|---|
| text | VARCHAR | — |
| num_topics | INTEGER | — |
| focus | VARCHAR | — |
LLM escape hatch extracts topics
SELECT
topics_llm ('Machine learning and neural networks')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-only topic extraction + assignment (escape hatch for TOPICS)
Per-row classifier — stable across GROUP BY.
TOPICS_LLM({{ text }})TOPICS_LLM({{ text }}, {{ num_topics }})TOPICS_LLM({{ text }}, {{ num_topics }}, '{{ focus }}')| name | type | description |
|---|---|---|
| text | VARCHAR | — |
| num_topics | INTEGER | — |
| focus | VARCHAR | — |
LLM escape hatch extracts topics
SELECT
topics_llm ('Machine learning and neural networks')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)