Manage OpenAI integration
The OpenAI integration allows Sigma to leverage OpenAI language models (including GPT-4 and embedding models) for features like visualization explanations and the formula assistant.1 You can integrate with OpenAI directly or through Azure OpenAI Service.
1 Sigma Computing is continuously working to improve and expand on existing functionality. This document will be updated as new AI features become available.
User requirements
The ability to configure the OpenAI integration in Sigma requires the following:
-
You must be assigned the Admin account type.
-
You must be able to provide the required authentication credentials.
Prerequisites
Before configuring the OpenAI integration, retrieve the authentication credentials from OpenAI or Azure, depending on your chosen integration method (direct or through Azure OpenAI Service).
OpenAI credentials (direct)
To integrate with OpenAI directly, your company must obtain, manage, and secure an OpenAI API key. You can retrieve the API key in the API keys section of your OpenAI developer platform.
For more information about your API key, see OpenAIβs Best practices for API key safety.
Azure OpenAI credentials
To integrate with OpenAI through Azure OpenAI Service, your company must have an Azure subscription with access to Azure OpenAI. For each language model, you must also provide the endpoint URL, model deployment name, and API key, which you can retrieve from your Azure portal or Azure OpenAI Studio (see the following table for guidance).
Sigma credential | Azure location |
---|---|
Endpoint URL | In the Azure portal, open the applicable resource page, then go to Resource Management > Keys and Endpoint and copy the URL in the Endpoint field. You can also find this value in Azure OpenAI Studio > Playground > Code View. |
Deployment Id (model deployment name) | In the Azure portal, open the applicable resource page, then go to Resource Management > Deployments and copy the model deployment name. This must be gpt-4-turbo or later (for a GPT-4 model) or text-embedding-3-small (for an Embeddings model). You can also find this value in Azure OpenAI Studio > Management > Deployments. |
API Key | In the Azure portal, open the applicable resource page, then go to Resource Management > Keys and Endpoint and copy the value in the KEY1 or KEY2 field. |
Add the OpenAI integration
If youβve retrieved the required credentials, you can quickly authenticate the OpenAI integration to enable AI functionality in Sigma. Refer to one of the following sections based on your chosen integration method.
OpenAI integration (direct)
-
Go to Administration > AI Settings:
-
In the Sigma header, click your user avatar to open the user menu.
-
Select Administration to open the Administration portal.
-
In the side panel, select AI Settings.
-
-
Locate the OpenAI setting and click Add.
-
In the Edit OpenAI Integration modal, configure the integration:
-
In the Provider field, select OpenAI.
-
In the API Key field, enter the OpenAI API key.
-
Click Save to authenticate.
When the integration is successfully authenticated, the OpenAI setting displays Remove and Edit buttons, and AI functionality is enabled for your organization. For more information about Sigmaβs AI features, see related resources at the end of this page.
-
Azure OpenAI integration
-
Go to Administration > AI Settings:
-
In the Sigma header, click your user avatar to open the user menu.
-
Select Administration to open the Administration portal.
-
In the side panel, select AI Settings.
-
-
Locate the OpenAI setting and click Add.
-
In the Edit OpenAI Integration modal, configure the integration:
-
In the Provider field, select Azure OpenAI.
-
Provide the required credentials for each language model:
-
In the Endpoint URL field, enter the endpoint URL.
-
In the Deployment Id field, enter the model deployment name.
-
In the API Key field, enter the Azure API key.
-
-
Click Save to authenticate.
When the integration is successfully authenticated, the OpenAI setting displays Remove and Edit buttons, and AI functionality is enabled for your organization. For more information about Sigmaβs AI features, see related resources at the end of this page.
-
Edit the OpenAI integration
You can edit the OpenAI integration at anytime to update the credentials.
-
Go to Administration > AI Settings.
-
In the Sigma header, click your user avatar to open the user menu.
-
Select Administration to open the Administration portal.
-
In the side panel, select AI Settings.
-
-
Locate the OpenAI setting and click Edit.
-
In the Edit OpenAI Integration modal, edit the credentials as needed, then click Save.
Remove the OpenAI integration
You can remove the OpenAI integration at any time to disable AI functionality within Sigma.
-
Go to Administration > AI Settings.
-
In the Sigma header, click your user avatar to open the user menu.
-
Select Administration to open the Administration portal.
-
In the side panel, select AI Settings.
-
-
Locate the OpenAI setting and click Remove.
-
In the Remove OpenAI Integration modal, click Remove to confirm.
When the integration is successfully removed, the OpenAI setting displays the Add button, and AI functionality is disabled for your organization.
Frequently Asked Questions
How do I request an OpenAI API key from Sigma?
Sigma doesnβt provide the OpenAI API key. To use the OpenAI integration, your company must obtain, manage, and secure its own OpenAI API key.
For more information, see Where do I find my secret API key?
How does Sigma secure the OpenAI integration?
Sigma encrypts all data exchanged through OpenAI API interactions.
Itβs important to note that Sigma doesnβt retain data exchanged through the API (like data provided through user prompts completions) or control how OpenAI uses it. Your company owns this data and can implement proper measures to safeguard data privacy and security according to its unique requirements.
Does OpenAI store my data or use it to train the AI language model?
No, the OpenAI API only processes user prompts and completions (output). OpenAI doesnβt store your API data or use it to train the language modelsβunless you explicitly opt in to share your data. If you donβt opt in, your API data isnβt incorporated into the language model ecosystem, and it will never be exposed in AI interactions outside your Sigma organization.
This statement was verified at the time Sigma began supporting the OpenAI integration. Sigma cannot control OpenAIβs policies, which may change in the future. For the most up-to-date information about how OpenAI stores and uses your data, see OpenAIβs API data usage policies.
Can Sigmaβs AI capabilities handle large-scale datasets from my warehouse?
Sigma doesnβt use the OpenAI integration to send API requests to your cloud data warehouse (CDW) or database management system (DBMS).
Can I restrict access to Sigmaβs AI capabilities and limit use to specific users?
No, you cannot directly control access to the AI features. Authorization is inherited from account types and workbook permissions.
Updated 4 days ago