Configure a usage dashboard for Sigma Assistant

Admins can configure a usage dashboard to view data about how Sigma Assistant is used in their Sigma organization. Monitor questions that users are asking Sigma Assistant, review performance and response times, and identify which sources are frequently used.

Data security

Sigma Assistant usage is visible in Usage dashboards, but only to users assigned the Admin account type. Unlike other usage dashboards, Sigma Assistant usage is collected only if you configure it, and usage data is stored in your data platform in a location that you specify.

🚩

Sigma Computing, Inc. does not store this data or have the ability to access it.

Because this data includes names of users and the full text of the questions they ask, Sigma recommends configuring a unique schema to store this data in your data platform and granting view privileges to that schema only to the admins who need access to this data.

Requirements

To set up the Sigma Assistant usage dashboard:

• You must be assigned the Admin account type.

• You must have a Sigma connection to a supported data platform and have write access enabled.

  • Connect to Snowflake
  • Connect to Databricks
  • Connect to BigQuery

Considerations for OAuth connections

If you connect to your data platform using OAuth, all users must be granted write access privileges in your data platform. Usage is not logged for users who aren't granted write access privileges (for example, BigQuery Data Editor role in BigQuery).

To limit which users must be granted write access privileges in your data platform, choose one of the following options:

• (Recommended) Create a dedicated connection to your data platform to use only for usage tracking. For instructions, see the following:

  • Set up a connection to Snowflake with write access using key pair authentication and a specific role.
  • Set up a connection to Databricks with write access using basic authentication and a service principal.
  • Set up a connection to BigQuery with write access using basic authentication.

• Use the existing OAuth connection and set up a dedicated write destination to use only for the Assistant usage dashboard and grant the relevant privileges only to that destination.

  For example, create a SIGMA catalog in Databricks, then create an ASSISTANT_USAGE schema. Only grant MODIFY and CREATE TABLE privileges on that schema to users who have permission to use Sigma Assistant in Sigma.

Configure the Sigma Assistant usage dashboard

After setting up a connection with write access, configure the Sigma Assistant usage dashboard:

1. Go to Administration > AI 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 AI Settings.

2. In the AI usage configuration section, for Connection, select a connection that has write access configured.

3. Based on the type of connection that you add, complete the additional fields to specify the write destination you configured, matching the capitalization of the objects in your data platform:

   • For a BigQuery connection, specify a ProjectID and Dataset configured as a write destination for the connection.
   • For a Databricks connection, specify a Catalog and Schema configured as a write destination for the connection.
   • For a Snowflake connection, specify a Database and Schema configured as a write destination for the connection.

4. Click Save.

   If you see an error "Cannot manage views on given scope with the following error: SQL access control error: Insufficient privileges to operate on schema 'your_schema_name'", the schema or dataset that you entered does not allow write access. Ensure that the write destination in your data platform is configured correctly.

After creating the dashboard, you can review usage from the Usage dashboards. See Usage overview.