Manage OpenAI integration

🚩

The OpenAI integration currently affects input tables only. If input tables (which require a Snowflake or Databricks connection) aren't enabled for your Sigma organization, users cannot leverage the current AI capabilities offered through the OpenAI integration.

The OpenAI integration allows Sigma to leverage OpenAI language models (including GPT-3.5 and GPT-4) for features like enhanced input tables with AI-generated columns.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:

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 this integration method, Sigma requires an API key, endpoint URL, and model deployment name, which you can retrieve from your Azure portal or Azure OpenAI Studio.

Sigma credentialAzure value
API KeyIn the Azure portal, go to Resource Management > Keys & Endpoint and copy the KEY1 or KEY2 value.
Azure OpenAI Base URL
(endpoint URL)
In the Azure portal, go to Resource Management > Keys & Endpoint and copy the Endpoint value.

You can also find this value in Azure OpenAI Studio > Playground > Code View.
Deployment Id
(model deployment name)
In the Azure portal, go to Resource Management > Deployments and copy the applicable model deployment name. This must be the name of a GPT-4 deployment.

You can also find this value in Azure OpenAI Studio > Management > Deployments.

Add 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)

  1. Go to Administration > Account > General Settings:

    1. In the Sigma header, click your user avatar to open the user menu.
    2. Select Administration to open the Administration portal.
    3. In the side panel, select Account, then open the General Settings tab.
  2. In the Integrations section, locate the OpenAI option and click Add.

  3. In the OpenAI Integration modal, configure the integration:

    1. Click the Provider field and select OpenAI from the dropdown.
    2. In the API Key field, enter your OpenAI API key.
    3. Click Save to authenticate.

    When the integration is successfully authenticated, the button changes from Add to Remove, 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

  1. Go to Administration > Account > General Settings:

    1. In the Sigma header, click your user avatar to open the user menu.
    2. Select Administration to open the Administration portal.
    3. In the side panel, select Account, then open the General Settings tab.
  2. In the Integrations section, locate the OpenAI option and click Add.

  3. In the OpenAI Integration modal, configure the integration:

    1. Click the Provider field and select Microsoft Azure OpenAI from the dropdown.
    2. In the API Key field, enter your API key.
    3. In the Azure OpenAI Base URL field, enter the endpoint URL.
    4. In the Deployment Id field, enter the model deployment name.
    5. Click Save to authenticate.

    When the integration is successfully authenticated, the button changes from Add to Remove, 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.

Remove OpenAI integration

You can remove the OpenAI integration at any time to disable AI functionality within Sigma.

  1. Go to Administration > Account > General Settings.

    1. In the Sigma header, click your user avatar to open the user menu.
    2. Select Administration to open the Administration portal.
    3. In the side panel, select Account, then open the General Settings tab.
  2. In the Integrations section, locate the OpenAI listing and click Remove.

  3. In the Remove OpenAI Integration modal, click Remove to confirm.

    When the integration is successfully removed, the button changes from Remove to Add, 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). The AI functionality currently applies to input tables only.

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. For example, the ability to create AI-generated input table columns is limited to users assigned to account types with the Edit Workbook permission enabled, and they must be granted Can edit access to the particular workbook containing the input table.