Skip to main content
Version: current [26.x]

Categories: Ai

AI_COMPLETE

Specialized form of AI_GENERATE for creative text generation and summaries, returned as VARCHAR.

Syntax​

AI_COMPLETE( [model_name VARCHAR,] prompt VARCHAR ) → VARCHAR​

  • model_name (optional): Optional model specification in format 'modelProvider.modelName' (e.g., 'gpt.4o'). modelProvider is the user-defined name for model provider configuration added in the preferences section (see Model Provider Configuration). modelName is one of the models supported and provided by that provider. If not provided, uses the default model for the organization.
  • prompt: Completion instruction for the LLM. Natural language text describing what you want the model to generate.

Examples

AI_COMPLETE example 
SELECT 
  dish_name, 
  AI_COMPLETE( 
    'Write an appetizing menu description for this dish: ' || dish_name || 
    '. Main ingredients: ' || main_ingredients || 
    '. Cooking style: ' || cuisine_type 
  ) AS menu_description 
FROM restaurant_dishes;

-- Sample output:
-- dish_name        | menu_description
-- Grilled Salmon   | Perfectly grilled Atlantic salmon with a delicate herb crust, served with seasonal vegetables and lemon butter sauce
-- Beef Tacos       | Authentic street-style tacos featuring tender slow-cooked beef, fresh cilantro, and house-made salsa verde
-- Chocolate Mousse | Rich and velvety French chocolate mousse topped with fresh berries and a hint of vanilla
-- Menu description generation

Usage Notes​

• Optimized for creative text generation and summaries that return a single text response.

• Always returns VARCHAR data type.

• If no model is specified, uses the default model set for the organization.

• Model specification format: 'modelProvider.modelName' (e.g., 'gpt.4o').