Dynamic column methods

+ Add Columns > Dynamic Columns opens the methods that compute a dynamic column’s values instead of you typing them in.

Name, Concurrency, and Status

Every method’s form asks for a Name for the resulting column, and every method except Conditional Node also asks for a Concurrency: how many rows to process in parallel. Retrieval’s forms note that leaving Concurrency blank falls back to the platform’s own system configuration. Conditional Node’s form only has a Name and the branch list; each branch’s operation carries its own Concurrency field instead, and skips its own Name field since the conditional column already has one.

The column’s status is Running while the method runs, then lands on Completed or Failed. Each cell carries its own status of running, pass, or error. See Limits & Data Types for the full list of status values.

Run Prompt

Produces a value from one inference call per row, using a prompt template.

Field	Description
Prompt	One or more messages (system, user, assistant); reference other columns with {{column_name}}
Model type	LLM, Text-to-Speech, Speech-to-Text, or Image Generation
Model	The model to run

The resulting column records source run_prompt.

Retrieval

Produces a value by querying a vector database index and returning matching chunks for each row.

Choose a Vector Database: Pinecone, Qdrant, or Weaviate. These fields are shared across all three:

Field	Description
Column	The column whose value is sent as the query
Number of chunks to fetch	How many top matches to fetch (topK)
Embedding Configuration	Type (OpenAI, Hugging Face, or Sentence Transformers) and Model
Key to extract	The field to pull from each retrieved match
Vector Length	The dimension the embedding model outputs; must match the index’s configured dimension

Each provider adds a few fields of its own, including its own API key field:

Provider	Additional fields
Pinecone	Pinecone API Key, Index Name, Namespace, Query Key
Qdrant	Qdrant API Key, Qdrant URL, Collection Name
Weaviate	Weaviate Api Key, Weaviate Cluster Url, Collection Name, Search Type (Semantic Search or Hybrid)

The resulting column records source vector_db.

Extract Entities

Produces a value extracted from a text column, guided by a model.

Field	Description
Column	The column to extract from
Instructions	What to extract
Model	The model to run

The resulting column records source extracted_entities.

Extract a JSON Key

Produces a value pulled out of a JSON column by key.

Field	Description
Column	A column of type JSON, or an API Call column whose response is JSON
JSON Key	The JSONPath-style key to extract, e.g. age

The resulting column records source extracted_json.

Classification

Produces a label assigned to a column’s text from your set of categories.

Field	Description
Column	The column to classify
Labels	One or more category labels
Model	The model to run

The resulting column records source classification.

API Calls

Produces a value returned by calling an external HTTP endpoint for each row.

Field	Description
Add API Endpoint	The endpoint to call; reference other columns with {{column_name}}
Request Type	GET, POST, PUT, DELETE, or PATCH
Params / Headers	Key-value pairs; each value is plain text, a stored secret, or a column reference
Request Body	JSON body; reference other columns with {{column_name}}
Output Type	String, Object, Array, or Number

The resulting column records source api_call.

Conditional Node

Produces a value chosen by evaluating branches in order: the first branch whose condition is true, or the else branch, runs its operation, and that operation’s output becomes the cell’s value.

Field	Description
Branches	One if (always first), any number of elif, and optionally one else
Condition	Set on every branch except else; reference other columns with {{column_name}}
Select Column Type	Per branch, one of Run Prompt, Retrieval, Extract Entities, Extract JSON Key, Execute Custom Code, Classification, or API Calls, configured with that operation’s own fields described on this page

The resulting column records source conditional.

Execute Custom Code

Produces a value returned by a Python function you write, run once per row. The function must be named main and can read any column’s value through kwargs (kwargs.get("column_name")). Execute Custom Code isn’t a standalone tile under Dynamic Columns. It’s only reachable as an operation inside a Conditional branch, or by editing a column that already runs Python code.

Field	Description
Code	The main(**kwargs) function to run

The resulting column records source python_code.