Skip to main content

Text Summary Tool (Live Query for Google BigQuery)

Use the Text Summary tool to shorten long-form content using AI to provide a quick overview. After you provide instructions, the tool summarizes the text in the selected column and writes a brief summary to the specified output column for each row.

Use this tool when working with large text fields such as documents, descriptions, or transcripts that require summarization.

Tool Availability

The Text Summary tool is available in the Google BigQuery tool palette.

Before using this tool...

  1. From a Cloud Native workflow, go to Options.

  2. Verify that Enable LiveQuery is enabled.

  3. Verify that the Selected Connection displays a BigQuery connection.

Tool Configuration

Column to Summarize

Use the Column to Summarize dropdown to select the column that contains the text to summarize.

Summary Instructions

Enter an instruction that describes how to summarize the data. For best results, clearly define the desired length, format, or focus of the summary. Write clear and specific instructions to get consistent results. The input is limited to 1000 characters.

For example:

Summarize the key points in this customer review.

Execute

Select Execute to run the Text Summary tool using the current settings and summarizing instructions.

Output Column Name

Enter a name for the output column in Output Column Name. If you don't specify a name, the tool appends _summarize to the input column name.

Output

The tool outputs a new column that contains the generated summary for each row.

Permission Required

To use this tool, assign these permissions to the BigQuery project or credentials (service account key or OAuth):

  • BigQuery API

  • Vertex AI API

  • BQ connection user