Skip to main content
Dremio Cloud Classic

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): 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. 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;
-- 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

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).