Skip to main content

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
  • Azure OpenAI
  • DeepSeek
  • Google Gemini
  • OpenAI
  • OpenAI Compatible
  • Open Router
  • xAI (Grok)

Configure your LLM​

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, see the provider tabs below.
  • 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. Share with Devs

Example Secret​

Example

Generative AI Use Cases with Datacoves Copilot​

Expand SELECT * into columns​

Generate Airflow DAG to run DBT​

LLM Providers​

Select your provider to see the secret value format and supported models:

Anthropic​

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-sonnet-4-5 (Recommended - default)
  • claude-sonnet-4-20250514
  • claude-opus-4-5-20251101
  • claude-opus-4-1-20250805
  • claude-opus-4-20250514
  • claude-haiku-4-5-20251001
  • 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.