Connecting to Cohere

The Cohere API uses API key authentication.

Using API Key Authentication

Your Cohere API Key is required to create a connection to Cohere. API Key can be obtained from your Cohere account at dashboard.cohere.com by navigating to the API Keys section. Once you have obtained the API key, set it in the ProfileSettings connection property.

Example Connection string

Profile=C:\profiles\Cohere.apip;ProfileSettings='APIKey=my_api_key;';AuthScheme=APIKey;

Usage Examples

ChatMessages:

SELECT * FROM ChatMessages WHERE Messages = '[
      {
        "role": "user",
        "content": "Tell me about LLMs"
      }
    ]' AND Model = 'command-a-vision-07-2025'

ChatMessages (assistant role):

SELECT * FROM ChatMessages WHERE Messages = '[
      {
        "role": "assistant",
        "content": "Tell me about LLMs"
      }
    ]' AND Model = 'command-a-vision-07-2025'

ChatMessages (tool role):

SELECT * FROM ChatMessages WHERE Messages = '[
      {
        "role": "tool",
        "tool_call_id": "1234",
        "content": "Tell me about LLMs"
      }
    ]' AND Model = 'command-a-vision-07-2025'

ChatMessages (system role):

SELECT * FROM ChatMessages WHERE Messages = '[
      {
        "role": "system",
        "content": "gasdga"
      }
    ]' AND Model = 'command-a-vision-07-2025'

Datasets:

SELECT * FROM Datasets

DatasetUsage:

SELECT * FROM DatasetUsage

Detokenize:

SELECT * FROM Detokenize WHERE Tokens = '2003,26354,6305,8446,1029' AND Model = 'embed-english-light-v3.0'

Embed:

SELECT * FROM Embed WHERE Model = 'embed-english-light-v3.0' AND InputType = 'classification' AND InputTexts = '["hi","bye"]'

EmbedJobs:

SELECT * FROM EmbedJobs

Models:

SELECT * FROM Models

Rerank:

SELECT * FROM Rerank WHERE Model = 'rerank-v4.0-fast' AND Query = 'What is the capital of the United States?' AND Documents = '["Carson City is the capital city of the American state of Nevada.","The search query to rank documents against"]'

Tokenize:

SELECT * FROM Tokenize WHERE Text = 'Who is issac newton?' AND Model = 'embed-english-light-v3.0'

Connection Properties

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider.

---

Property	Description
APIKey	Your Cohere API key used for authentication.
AuthScheme	The scheme used for authentication. Accepted entries are APIKey or None. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT