surface↓pipeline↓skill_json
Pipelinescalar · returns varchar

SKILL_JSON

Call a skill and return JSON content directly (for json_extract_string)

Per-row — runs once for each row.

pipelinellmjson

Arguments

nametypedescription
skill_nameVARCHARName of skill to call
args(optional)VARCHARJSON object of arguments

About

Call any registered skill and return JSON content directly. Unlike skill() which returns a table via read_json_auto(), skill_json() returns raw JSON as VARCHAR for use with json_extract_string() in scalar extraction scenarios. SQL Usage: SELECT json_extract_string(skill_json('local_sentiment', '{"text": "I love it"}'), '$.label') FROM messages; SELECT json_extract_string( skill_json('word_count', json_object('text', message)), '$.count' ) as word_count FROM documents;

Nearby rabbit holes

same domain
pipeline

ADD_STYLES

Apply theme styling to a chart specification

pipelinellmpipeline-composabletext
pipeline

ANALYZE

Analyze query results with LLM based on a prompt

pipelinellmpipeline-composabletext
pipeline

DEDUPE

Remove duplicate rows

pipelinellmpipeline-composabletext
pipeline

ENRICH

Add LLM-computed columns to query results

pipelinellmpipeline-composabletext
pipeline

FILTER

Filter query results using LLM-based semantic matching

pipelinellmpipeline-composabletext
pipeline

GROUP

Group by column and aggregate another

pipelinellmpipeline-composabletext
Climb back to The Looking Glass