LLM-backed looks_like (escape hatch for LOOKS_LIKE)
Per-row — runs once for each row.
LOOKS_LIKE_LLM({{ value }}, '{{ expected_type }}'){{ value }} LOOKS_LIKE_LLM '{{ expected_type }}'| name | type | description |
|---|---|---|
| value | VARCHAR | — |
| expected_type | VARCHAR | Type to check (free-form) |
LLM escape hatch: malformed email
SELECT
looks_like_llm ('john@gmail', 'email')LLM escape hatch: address
SELECT
looks_like_llm ('123 Main St', 'address')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 looks_like (escape hatch for LOOKS_LIKE)
Per-row — runs once for each row.
LOOKS_LIKE_LLM({{ value }}, '{{ expected_type }}'){{ value }} LOOKS_LIKE_LLM '{{ expected_type }}'| name | type | description |
|---|---|---|
| value | VARCHAR | — |
| expected_type | VARCHAR | Type to check (free-form) |
LLM escape hatch: malformed email
SELECT
looks_like_llm ('john@gmail', 'email')LLM escape hatch: address
SELECT
looks_like_llm ('123 Main St', 'address')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)