Overview

​

1. Available Aggregate Functions

1. llm_reduce: Summarize or consolidate a group
2. llm_rerank: Reorder rows by relevance (sliding window)
3. llm_first: Most relevant row in a group
4. llm_last: Least relevant row in a group

​

2. Context Columns API

'context_columns': [
  {'data': column_name},
  {'data': column_name, 'name': 'alias'},
  {'data': image_url, 'type': 'image'},
  {'data': audio_path, 'type': 'audio', 'transcription_model': 'whisper-1'}
]

​

3. When to Use Aggregate Functions

• Summarization: llm_reduce over text, image collections, or audio clips
• Ranking: llm_first, llm_last, or llm_rerank by text, visual, or spoken criteria
• Structured output: JSON schemas via model_parameters — see each function’s Output section