AI Assistant Configuration for Team & Enterprise

Coginiti's AI Assistant is a powerful set of AI-driven features to help you do more with data.

⚠️ Please note that the following features are experimental. It is important to remember that AI-generated code may not always be accurate, complete, or free from bias. The AI Assistant is designed to supplement human insight and judgment, not replace it. As a human, please be aware that you must still click a "run" button and determine whether the generated code is correct.

Getting Started

As an Admin can set up a connection to AI Assistant by following these steps:

1. Go to the Admin Settings -> Global Preferences -> AI Assistant, check the checkbox to enable AI Assistant, and then choose the generative AI model from the top menu.
2. Fill in the following credentials to set up a connection.
3. Check the Share database metadata with AI Assistant box, it can make your AI-generated code more accurate.
4. Click Apply to enable AI Assistant for all users in your organization.

Azure OpenAI

To use the AI Assistant, you need an Azure subscription that has been approved for access to the Azure OpenAI (to sign up for an Azure subscription, press here and to request access to the Azure OpenAI service, press here ). Once your account is set up, you can connect to

Credentials to set up a connection:

• Resource Name – To create a resource, refer to the Azure OpenAI documentation. Once the resource is created in the Azure OpenAI Service, go to Resource Management > Keys and Endpoints. Copy and paste the endpoint into the Resource Name field.
• API Key – You can find API Keys in your Azure OpenAI Service page Resource Management -> Keys and Endpoints.
• Deployment Name – After creating an Azure OpenAI Resource, you must deploy a model. In the Deployment Name field, enter the name you chose during model deployment. You can find it in Azure OpenAI Studio under Management > Deployments.

Amazon Bedrock

To access the AI Assistant, you must be granted access to the model before you can use it (more information can be found in Amazon Bedrock documentation). Once your account is set up, you can connect to Amazon’s Bedrock in Coginiti.

Credentials to set up a connection:

• Access Key ID
• Secret Access Key
• Region
• Model – You can select the model that best suits your needs. Currently, we support the following Anthropic models: Claude, Claude 2.1, and Claude Instant.

OpenAI

To access the AI Assistant, you must have a paid account with OpenAI (to create an OpenAI paid account press here).  Once your account is set up, you can connect to OpenAI's ChatGPT in Coginiti.

Credentials to set up a connection:

• API Key - To receive API key register on the OpenAI platform. Open the API Keys section in your profile and click the "Create new secret key" button. Copy and paste the new secret key in the API token field.
• Model – You can select the model that best suits your needs. 

Anthropic

To access the AI Assistant, you must have a paid account with Anthropic (to create an Anthropic account press here).

Credentials to set up a connection:

• API Key - To receive the API key, sign up at Claude.ai. Open the API Keys section in your profile and click the "Create Key" button. Please note that the minimum role required is 'developer' to access the API key. Copy and paste the new secret key in the API token field.
• Model – You can select the model that best suits your needs.

Disabling the AI Assistant

Go to Admin Settings -> Global Preferences -> AI Assistant and uncheck the checkbox to disable AI Assistant.

To learn more about using AI Assistant for tasks like code generation, SQL query explanation, optimization, error fixing, and more, please refer to the Using the AI Assistant article.