AI Functions

Oracle Analytics provides AI-powered functions that you can use to apply large language models (LLMs) inside your SQL queries.

The AI functions invoke models registered as model assets. Model assets define how Oracle Analytics connects to an AI service and which model is used.

Supported model asset types include:

• Oracle Cloud Infrastructure models - You register these models with an API key or by resource principals.
• Oracle Autonomous AI Lakehouse models - You register these models with AI profiles.

Each function accepts text input, a prompt or predicate, and a model identifier. The functions differ in how they evaluate rows and return results.

Each function requires you to specify a model ID parameter to identify the query's target model. The model must be registered before you can run your query successfully. See Typical Workflow to Integrate Oracle Analytics with Generative AI Models.

For more information about Oracle Analytics AI functions, see Overview to Using Generative AI Models in Oracle Analytics.

Functions:

• AI Generate Function

• AI Filter Function

• AI Aggregate Function