AI_CLASSIFY

Applies to: ✅ Data 360 SQL ❌ Tableau Hyper API

Analyzes text and classifies it into the best matching category from a list of categories you define. This function uses the classification model to categorize support cases, customer inquiries, product feedback, and other unstructured text.

Syntax

ai_classify(<input_text>, <input_categories>)

Arguments

Required

<input_text>: The text to classify.
<input_categories>: A text array of categories with at least one unique value. An empty category list results in the Input categories cannot be empty validation error message.

Returns

After analyzing the input_text, returns the category with the highest confidence score from the input_categories.

Considerations

Input text length: The function supports input text up to 512 tokens (approximately 400-500 words). For longer text such as full emails or lengthy documents, split the content into shorter passages before classifying.
Best for short text: This function works best on short, intent-rich text such as support case descriptions, product inquiries, and customer feedback.
Category consistency: The input_categories parameter must be constant across all rows in the query.
Performance: Requests to the function time out after 30 seconds.
First execution: When executing this function on a large number of rows for the first time, you can encounter timeout or capacity errors. Start with smaller row counts and gradually increase volume to avoid these issues.
Non-NULL values: input_text must be a non-NULL value. Add IS NOT NULL to the WHERE clause in your SQL statement to avoid NULL value errors.
Multilingual support: The underlying model supports multiple languages.

Examples

Basic Usage

Classify issues in an automobile repair center based on the type of issue.

SELECT
  "issuesIdentified__c",
  ai_classify(input_text=>"issuesIdentified__c",
  input_categories=>'["Engine", "Chassis", "Electrical"]') AS category
  FROM "AutomobileServiceFeedback__dll"

Returns:

issuesIdentified__c	category
Electrical system failure causing intermittent starting and dashboard warnings	Electrical
Shock absorber replacement due to oil leakage and poor ride quality	Chassis
Engine overheating issue traced to failed radiator and thermostat replacement	Engine
Exhaust system repair and catalytic converter replacement	Engine
Steering system malfunction requiring tie rod and power steering pump replacement	Chassis

Filter Classification Results

Returns only the rows matching the defined classification.

WITH ClassifiedIssues AS (
  SELECT
    "serviceCenterName__c",
    "costOfService__c",
    "issuesIdentified__c",
    ai_classify(
      input_text => "issuesIdentified__c",
      input_categories => '["Engine", "Chassis", "Electrical"]'
    ) AS category
  FROM "AutomobileServiceFeedback__dll"
)
SELECT * FROM ClassifiedIssues
WHERE category = 'Engine';

Returns all reported vehicle issues related to the engine.