Datacoves Copilot v2

This section describes how to configure and use Datacoves Copilot v2, which comes installed on Datacoves v4+, enhancing the experience and supporting the following LLM providers:

• Anthropic
• DeepSeek
• Google Gemini
• OpenAI
• OpenAI Compatible (i.e. Azure)
• Open Router
• xAI (Grok)

How Tos

Config

Configure your LLM in Datacoves Copilot v2

Create a Datacoves Secret

Creating a Datacoves Secret requires some key fields to be filled out:

• Name: The secret must be named datacoves-copilot-api-configs
• Description: Provide a simple description such as: Datacoves Copilot config
• Format: Select Raw JSON
• Value: The value will vary depending on the LLM you are utilizing, click on the corresponding tab or on More Providers to see more.
• Scope: Select the desired scope, either Project or Environment.
• Project/Environment: Select the Project or Environment that will access this LLM.

Lastly, be sure to toggle on the Share with developers option so that users with developer access will be able to use the LLM.

Example Secret

Learn more about Generative AI Use Cases with Datacoves Copilot

Expand SELECT * into columns

Generate Airflow DAG to run DBT

Anthropic

Anthropic LLM Provider

Anthropic is an AI safety and research company that builds reliable, interpretable, and steerable AI systems. Their Claude models are known for their strong reasoning abilities, helpfulness, and honesty.

Website: https://www.anthropic.com/

Secret value format

{
  "default": {
    "todoListEnabled": true,
    "consecutiveMistakeLimit": 3,
    "apiKey": "<YOUR API KEY>",
    "apiModelId": "<MODEL ID>",
    "apiProvider": "anthropic",
    "id": "default"
  }
}

Getting an API Key

1. Sign Up/Sign In: Go to the Anthropic Console. Create an account or sign in.
2. Navigate to API Keys: Go to the API keys section.
3. Create a Key: Click "Create Key". Give your key a descriptive name (e.g., "Datacoves").
4. Copy the Key: Important: Copy the API key immediately. You will not be able to see it again. Store it securely.

Supported Models (apiModelId)

Datacoves Copilot supports the following Anthropic Claude models:

• claude-opus-4-1-20250805
• claude-opus-4-20250514
• claude-sonnet-4-20250514 (Recommended)
• claude-3-7-sonnet-20250219
• claude-3-7-sonnet-20250219:thinking (Extended Thinking variant)
• claude-3-5-sonnet-20241022
• claude-3-5-haiku-20241022
• claude-3-opus-20240229
• claude-3-haiku-20240307

See Anthropic's Model Documentation for more details on each model's capabilities.

OpenAI

OpenAI LLM Provider

Datacoves Copilot supports accessing models directly through the official OpenAI API, including the latest GPT-5 family with advanced features like reasoning effort control and verbosity settings.

Website: https://openai.com/

Secret value format

{
  "default": {
    "reasoningEffort": "medium",
    "apiModelId": "<MODEL ID>",
    "openAiNativeApiKey": "<YOUR API KEY>",
    "apiProvider": "openai-native",
    "id": "default"
  }
}

Getting an API Key

1. Sign Up/Sign In: Go to the OpenAI Platform. Create an account or sign in.
2. Navigate to API Keys: Go to the API keys page.
3. Create a Key: Click "Create new secret key". Give your key a descriptive name (e.g., "Datacoves").
4. Copy the Key: Important: Copy the API key immediately. You will not be able to see it again. Store it securely.

Supported Models (apiModelId)

GPT-5 Family (Latest)

The GPT-5 models are OpenAI's most advanced, offering superior coding capabilities and agentic task performance:

• gpt-5-2025-08-07 (default) - Best model for coding and agentic tasks
• gpt-5-mini-2025-08-07 - Faster, cost-efficient for well-defined tasks
• gpt-5-nano-2025-08-07 - Fastest, most cost-efficient option

GPT-5-Codex

OpenAI's specialized coding model with advanced capabilities:

Key Features:

400K Token Context Window - Process entire codebases and lengthy documentation Image Support - Analyze screenshots, diagrams, and visual documentation Prompt Caching - Reduced costs for repeated context through automatic caching Adaptive Reasoning - Dynamically adjusts reasoning depth based on task complexity

Ideal for: Large-scale code analysis, multimodal tasks requiring visual understanding, complex refactoring projects, and extensive codebase operations.

GPT-4.1 Family

Advanced multimodal models with balanced capabilities:

• gpt-4.1 - Advanced multimodal model
• gpt-4.1-mini - Balanced performance
• gpt-4.1-nano - Lightweight option

o3 Reasoning Models

Models with configurable reasoning effort for complex problem-solving:

• o3, o3-high, o3-low - Different reasoning effort presets
• o3-mini (medium reasoning effort)
• o3-mini-high (high reasoning effort)
• o3-mini-low (low reasoning effort)

o4 Models

Latest mini reasoning models:

• o4-mini
• o4-mini-high
• o4-mini-low

o1 Family

Original reasoning models:

• o1 - Original reasoning model
• o1-preview - Preview version
• o1-mini - Smaller variant

GPT-4o Family

Optimized GPT-4 models:

• gpt-4.5-preview
• gpt-4o - Optimized GPT-4
• gpt-4o-mini - Smaller optimized variant

Refer to the OpenAI Models documentation for the most up-to-date list of models and capabilities.

OpenAI Compatible

OpenAI Compatible

OpenAI Compatible LLM Providers

Datacoves Copilot supports a wide range of AI model providers that offer APIs compatible with the OpenAI API standard. This means you can use models from providers other than OpenAI, while still using a familiar API interface. This includes providers like:

• Local models running through tools like Ollama and LM Studio (covered in separate sections).
• Cloud providers like Azure, Perplexity, Together AI, Anyscale, and others.
• Any other provider offering an OpenAI-compatible API endpoint.

Secret value format

{
  "default": {
    "reasoningEffort": "medium",
    "openAiBaseUrl": "<BASE URL>",
    "openAiApiKey": "<YOUR API KEY>",
    "openAiModelId": "<MODEL ID>",
    "openAiUseAzure": false,
    "azureApiVersion": "",
    "openAiHeaders": {},
    "apiProvider": "openai",
    "id": "default"
  }
}

Where:

1. openAiBaseUrl: This is the API endpoint for the provider. It will not be https://api.openai.com/v1 (that's for the official OpenAI API).
2. openAiApiKey: This is the secret key you obtain from the provider.
3. openAiModelId: This is the model name of the specific model, each provider will expose a different set of models, please check provider's documentation.

If you're using Azure, please set "openAiUseAzure": true, optionally you could specify a specific API version using "azureApiVersion": "<VERSION>".

Fine tune model usage

Fine tune model usage using this additional configuration under the openAiCustomModelInfo key.

"openAiCustomModelInfo": {
    "maxTokens": -1,
    "contextWindow": 128000,
    "supportsImages": true,
    "supportsPromptCache": false,
    "inputPrice": 0,
    "outputPrice": 0,
    "reasoningEffort": "medium"
}

Google Gemini

Google Gemini LLM Provider

Datacoves Copilot supports Google's Gemini family of models through the Google AI Gemini API.

Website: https://ai.google.dev/

Secret value format

{
  "default": {
    "apiModelId": "<MODEL ID>",
    "geminiApiKey": "<YOUR API KEY>",
    "apiProvider": "gemini",
    "id": "default"
  }
}

Getting an API Key

1. Go to Google AI Studio: Navigate to https://ai.google.dev/.
2. Sign In: Sign in with your Google account.
3. Create API Key: Click on "Create API key" in the left-hand menu.
4. Copy API Key: Copy the generated API key.

Supported Models (apiModelId)

Datacoves Copilot supports the following Gemini models:

Model Aliases (Recommended)

For stability and automatic updates, use these aliases that point to the latest stable versions:

• gemini-flash-latest - Always uses the newest stable Flash model
• gemini-pro-latest - Always uses the newest stable Pro model

Standard Models

• gemini-2.5-flash-preview-05-20
• gemini-2.5-flash-preview-04-17
• gemini-2.5-flash-lite-preview-06-17
• gemini-2.5-pro-exp-03-25
• gemini-2.0-flash-001
• gemini-2.0-flash-lite-preview-02-05
• gemini-2.0-pro-exp-02-05
• gemini-2.0-flash-exp
• gemini-1.5-flash-002
• gemini-1.5-flash-exp-0827
• gemini-1.5-flash-8b-exp-0827
• gemini-1.5-pro-002
• gemini-1.5-pro-exp-0827
• gemini-exp-1206

Preview Models

Preview models include Google's latest experimental features but may change without notice:

• Models with -preview- in the name (e.g., gemini-2.5-flash-preview-05-20)
• Models with -exp- suffix (e.g., gemini-2.0-flash-exp)
• Models prefixed with gemini-exp- (e.g., gemini-exp-1206)

Preview models are ideal for testing cutting-edge capabilities but may have breaking changes. Use stable aliases for production work.

Thinking Models

These models require reasoning budget to be enabled in Datacoves Copilot:

• gemini-2.5-flash-preview-05-20:thinking
• gemini-2.5-flash-preview-04-17:thinking
• gemini-2.0-flash-thinking-exp-01-21
• gemini-2.0-flash-thinking-exp-1219

Refer to the Gemini documentation for more details on each model.

More Providers

Additional LLM Providers

Datacoves Copilot supports additional LLM providers, you can find the secret value format for each one of them and additional documentation.

DeepSeek

Datacoves Copilot supports accessing models through the DeepSeek API, including deepseek-chat and deepseek-reasoner.

Website: https://platform.deepseek.com/

Secret value format

{
  "default": {
    "apiModelId": "<MODEL ID>",
    "deepSeekApiKey": "<YOUR API KEY>",
    "apiProvider": "deepseek",
    "id": "default"
  }
}

Getting an API Key

1. Sign Up/Sign In: Go to the DeepSeek Platform. Create an account or sign in.
2. Navigate to API Keys: Find your API keys in the API keys section of the platform.
3. Create a Key: Click "Create new API key". Give your key a descriptive name (e.g., "Datacoves").
4. Copy the Key: Important: Copy the API key immediately. You will not be able to see it again. Store it securely.

Supported Models (apiModelId)

• deepseek-chat (Recommended for coding tasks)
• deepseek-reasoner (Recommended for reasoning tasks)
• deepseek-r1

Open Router

OpenRouter is an AI platform that provides access to a wide variety of language models from different providers, all through a single API. This can simplify setup and allow you to easily experiment with different models.

Website: https://openrouter.ai/

Secret value format

{
  "default": {
    "reasoningEffort": "medium",
    "openRouterApiKey": "<YOUR API KEY>",
    "openRouterModelId": "<MODEL ID>",
    "apiProvider": "openrouter",
    "id": "default"
  }
}

Getting an API Key

1. Sign Up/Sign In: Go to the OpenRouter website. Sign in with your Google or GitHub account.
2. Get an API Key: Go to the keys page. You should see an API key listed. If not, create a new key.
3. Copy the Key: Copy the API key.

Supported Models (openRouterModelId)

OpenRouter supports a large and growing number of models. Refer to the OpenRouter Models page for the complete and up-to-date list.

xAI Grok

xAI is the company behind Grok, a large language model known for its conversational abilities and large context window. Grok models are designed to provide helpful, informative, and contextually relevant responses.

Website: https://x.ai/

Secret value format

{
  "default": {
    "reasoningEffort": "medium",
    "apiModelId": "<MODEL ID>",
    "xaiApiKey": "<YOUR API KEY>",
    "apiProvider": "xai",
    "id": "default"
  }
}

Getting an API Key

1. Sign Up/Sign In: Go to the xAI Console. Create an account or sign in.
2. Navigate to API Keys: Go to the API keys section in your dashboard.
3. Create a Key: Click to create a new API key. Give your key a descriptive name (e.g., "Datacoves").
4. Copy the Key: Important: Copy the API key immediately. You will not be able to see it again. Store it securely.

Supported Models (apiModelId)

• grok-code-fast-1 (Default) - xAI's Grok Code Fast model with 262K context window and prompt caching, optimized for reasoning and coding tasks
• grok-4 - xAI's Grok-4 model with 262K context window, image support, and prompt caching
• grok-3 - xAI's Grok-3 model with 128K context window and prompt caching
• grok-3-fast - xAI's Grok-3 fast model with 128K context window and prompt caching
• grok-3-mini - xAI's Grok-3 mini model with 128K context window, reasoning support, and prompt caching
• grok-3-mini-fast - xAI's Grok-3 mini fast model with 128K context window, reasoning support, and prompt caching
• grok-2-1212 - xAI's Grok-2 model (version 1212) with 128K context window
• grok-2-vision-1212 - xAI's Grok-2 Vision model (version 1212) with image support and 32K context window

Learn more about available models at xAI Docs.