Classify Tool (Live Query for Google BigQuery)
Use the Classify tool to assign categories to text using AI. This helps you organize and group text based on the classes you define. The tool predicts the class for each row and writes the result to the specified output column.
Use this tool when you want to categorize text such as customer feedback, support tickets, survey responses, or transcripts.
Tool Availability
The Classify tool is available in the Google BigQuery tool palette.
Before using this tool...
From a Cloud Native workflow, go to Options.
Verify that Enable LiveQuery is enabled.
Verify that the Selected Connection displays a BigQuery connection.
Tool Configuration
Column to Classify
Use the Column to Classify dropdown to select the column that contains the text to classify.
Classes
Enter the list of categories that you want the model to use when classifying your data. Type a class name and press Enter to add it to the list. Enter at least 2 classes.
For best results, use clear and distinct class names. For example:
Positive,Neutral,NegativeBilling Issue,Technical Issue,Account Access
Execute
Select Execute to run the classification using the current classes. If you update the classes, select Execute again to refresh the results.
Output Column Name
Enter a name for the output column in Output Column Name. If you don't specify a name, the tool appends _classify to the input column name.
Output
The tool outputs a new column that contains the predicted class for each row.
Permission Required
To use this tool, assign the Vertex AI API permission to the BigQuery project or credentials (service account key or OAuth):