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.