Anthropic / Claude

-- Minimal: API key only (uses default API version)
CREATE SECRET (
    TYPE ANTHROPIC,
    API_KEY 'your-api-key'
);

-- With custom API version (optional)
CREATE SECRET (
    TYPE ANTHROPIC,
    API_KEY 'your-api-key',
    API_VERSION '2024-01-01'
);

CREATE MODEL(
   'ClaudeModel',
   'claude-sonnet-4-5',
   'anthropic',
   {"tuple_format": "json", "max_batch_size": 32, "model_parameters": {"temperature": 0.7, "max_tokens": 1024}}
);

SELECT llm_complete(
    {'model_name': 'ClaudeModel'},
    {'prompt': 'Explain what a database is in simple terms'}
);

CREATE MODEL(
   'ClaudeCustom',
   'claude-sonnet-4-5',
   'anthropic',
   {
     "model_parameters": {
       "temperature": 0.5,
       "max_tokens": 2048,
       "system": "You are a helpful data analyst assistant."
     }
   }
);

CREATE MODEL(
   'AnalystClaude',
   'claude-sonnet-4-5',
   'anthropic',
   {
     "model_parameters": {
       "system": "You are an expert data analyst. Always provide structured, actionable insights.",
       "max_tokens": 1024
     }
   }
);

SELECT llm_complete(
    {'model_name': 'ClaudeModel'},
    {
        'prompt': 'Describe what you see in this image',
        'context_columns': [
            {'data': image_column, 'type': 'image'}
        ]
    }
) AS description
FROM images_table;

SELECT llm_complete(
    {'model_name': 'ClaudeModel',
     'model_parameters': '{
       "output_format": {
         "type": "json_schema",
         "schema": {
           "type": "object",
           "properties": {
             "sentiment": {"type": "string"},
             "confidence": {"type": "number"}
           },
           "required": ["sentiment", "confidence"],
           "additionalProperties": false
         }
       }
     }'
    },
    {'prompt': 'Analyze the sentiment of this text: I love this product!'}
) AS analysis;

-- For embeddings, use a different provider
CREATE MODEL('EmbeddingModel', 'text-embedding-3-small', 'openai');

-- Use Claude for completions
CREATE MODEL('ClaudeModel', 'claude-sonnet-4-5', 'anthropic');