surfacesummarizationsummarize
Summarizationaggregate · returns varchar

SUMMARIZE

Summarize a group of texts into one concise overview

Per-group — reads the whole group in one call.

summarizationllmtext

Syntax

summarize({{ texts }})
SUMMARIZE({{ texts }})

Arguments

nametypedescription
textsJSON

About

Summarize a collection of text values into a concise overview. Used as a SQL aggregate — drop it into a GROUP BY to get one summary per group. Useful for turning thousands of customer comments into a readable executive summary by category, rolling up a month of support tickets per product, or distilling a long discussion thread into key points. For per-row summarization (one summary per text, not one summary per group), use CONDENSE or TLDR instead.

Examples

Summarizes multiple texts about weather into overview

WITH
  test_data AS (
    SELECT
      *
    FROM
      (
        VALUES
          ('The weather was sunny and warm'),
          ('It was a beautiful day for outdoor activities'),
          ('Perfect conditions for a picnic in the park')
      ) AS t (review)
  )
SELECT
  SUMMARIZE (review)
FROM
  test_data

Nearby rabbit holes

same domain
Climb back to The Looking Glass