AI Functions
Data 360 Query Guide, mirrored from developer.salesforce.com: These functions enable text processing by using machine learning or generative AI.
markdownreferencev18GYK-63NXguide: data-cloud-query-guidestage: referencetrust: officialsource: developer.salesforce.comservice: data360interface: sqlAI FunctionsData 360Data CloudData 360 Query Guide
Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/ai-funcs.html> (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers.
AI Functions
These functions enable text processing by using machine learning or generative AI.
AI functions are essential tools for data transformation and analysis. Use them to:
- Analyze text sentiment to gauge emotional tone.
- Classify text into predefined categories for reporting and segmentation.
- Generate or summarize text inline by calling a large language model.
- Integrate sophisticated AI/ML capabilities directly into your SQL queries for interactive analysis.
AI_SENTIMENT: Analyzes text and returns a sentiment label.AI_CLASSIFY: Classifies text into user-defined categories.AI_GENERATE_TEXT: Generates or summarizes text by calling a large language model.
- String Functions and Operators: traditional functions for concatenation, trimming, and case conversion.
- String Types: understanding text and character data types.