Account type and license overview

🚩

If your organization utilizes the Lite/Essential/Pro license model, refer to https://help.sigmacomputing.com/docs/license-and-account-type-overview-2024.

Account types and licenses are foundational components of Sigma’s user management and pricing structure. Account types enable the selection of granular permissions that determine how users access and interact with data and documents in Sigma. The selected permissions determine the account type’s license tier used for billing purposes.

This document outlines Sigma's license tiers and explains the relationship between account types and licenses. It also provides a comprehensive comparison of permissions that determine which license is assigned to each account type.

For information about using account types, see Create and manage account types. For information about license pricing, contact your Account Executive or Customer Success Manager.

License tiers

Sigma offers four license tiers that support different service levels to accommodate your organization’s diverse user requirements and access control policies. The following table describes model users and key capabilities of each license tier.

ViewActAnalyzeBuild1

Suitable for report consumers who need access to prepared data and insights with baseline interactions.


Highlights

  • View workbooks
  • Use predefined controls and drill paths
  • View aggregated underlying data
  • Export to PDF and PNG
  • Add and view comments
  • Designate workbooks as favorites

Ideal for collaborative data contributors who actively input and update data.


View license capabilities, plus:

  • Submit forms and edit input tables
  • Trigger actions
  • Send notifications
  • Run external actions (email, Slack, webhooks, stored procedures)
  • Annotate comments
  • View and filter underlying data

Optimized for decision-making data consumers who require more deep-dive capabilities without building workbooks themselves.


Act license capabilities, plus:

  • Perform ad hoc analysis
  • Schedule reports
  • Export to CSV, Excel, and Google Sheets
  • Create alerts

Designed for data architects, BI analysts, and report builders who model, transform, and analyze data.


Analyze license capabilities, plus:

  • Create, edit, and share workbooks
  • Build data apps and workflows with actions
  • Model share, and materialize data
  • Export data to cloud services
  • Manage users, integrations, and connections
  • Write SQL and Python
  • View Custom SLQ logic
  • </ul

1The Build license also supports system administrators who can manage organization settings and users.

Account type and license relationship

Account types enable admin users to select granular permissions that determine which features and capabilities organization users can access. Sigma automatically assigns a license to each account type based on the highest license tier of the enabled permissions. This relationship allows for more flexible and scalable access control that adapts to ongoing changes in your user base and user requirements.

Account type permission availability matrix

The following table compares the account type permissions associated with each license tier. When configuring an account type, admins can enable or disable any combination of permissions within and across license tiers.

 ViewActAnalyzeBuild
Data warehouse
Connections

View connections

Browse connections, schemas, and database tables

nononoyes

Manage connections1

Create new connections and manage existing ones

(Automatically enables the View connections permission)

nononoyes
Tables

Annotate tables1

Annotate database tables (edit column details, metrics, and links)

nononoyes
Write-back
Input tables

Create input tables2

Create and edit input tables in workbooks

nononoyes
Materialization

Schedule materializations2

Create and edit materialization schedules

nononoyes
CSV

Upload CSV

Upload and analyze CSV data

nononoyes
Warehouse views

Create warehouse views2

Create warehouse views based on datasets and workbook elements

nononoyes
Data modeling
Datasets

View datasets2

View existing datasets and data models

yesyesyesyes

Create, edit, and publish datasets2

Create and manage datasets and data models

(Automatically enables the View datasets permission)

nononoyes
Features

Write Python

Run Python code in your data platform

nononoyes

Write SQL

Query a connected data platform directly with SQL

nononoyes
Documents
Workbooks

View workbooks2

View and interact with explorations and published workbooks

yesyesyesyes

Can comment on workbooks4

View and add comments on workbooks

yesyesyesyes

Basic explore2,3

View and interact with explorations and published workbooks with added ability to drill into data, filter columns, enter input table data, and more

(Automatically enables the View workbooks permission)

noyesyesyes

Full explore2,3

Modify workbook elements to create custom views of published workbooks

(Automatically enables the Basic explore and View workbooks permissions)

nonoyesyes

Create, edit, and publish workbooks2

Create new workbooks and manage existing ones

(Automatically enables the Full explore, Basic explore, and View workbooks permissions)

nononoyes

Set workbook data refresh2

Set an automatic data refresh schedule for a workbook

(Automatically enables the Create, edit, and publish workbooks permission)

nononoyes

AI features

Can use features that rely on large language models feature

nononoyes
Version tags

Apply tag2

Apply version tags to workbooks or data models

nononoyes
Org management
Usage dashboard

View usage dashboard

View the organization dashboard

nononoyes

View SQL in usage dashboard

View raw SQL in the organization usage dashboard

(Automatically enables the View usage dashboard permission)

nononoyes
Branding settings

Manage all branding settings

Manage organization branding settings, including workbook themes, custom fonts, and system emails

nononoyes

Manage all workbook themes and fonts

Create, edit, and delete workbook themes and custom fonts

nononoyes
Plugins

Manage plugins

Access plugin development features and manage custom plugins

nononoyes
Badges

Manage all badges

Add, change, and remove workbook badges (Endorsed, Warning, or Deprecated)

nononoyes
Sharing / folders
Sharing and exports

Download2

Immediately download entire workbooks, specific pages, and individual elements

nonoyesyes

Export to email2

Export entire workbooks, specific pages, and individual elements by email

(Automatically enables the Download permission)

nonoyesyes

Run exports as recipient2

Choose to run exports as the recipients.

(Automatically enables the Download and Export to Email permissions)

nonoyesyes

Export to Google Sheet2

Export data to Google Sheets spreadsheets

(Automatically enables the Download permission)

nonoyesyes

Export to Google Drive2

Export data to Google Drive folders

(Automatically enables the Download permission)

nonoyesyes

Export to Slack2

Export data to Slack channels

(Automatically enables the Download permission)

nonoyesyes

Schedule export2

Create, edit, and delete scheduled exports and alerts to send entire workbooks, specific pages, and individual elements

(Automatically enables the Download and Export to Email permissions)

nonoyesyes

Share documents2

Share folders and documents with organization members

nononoyes

Export to cloud2

Export data to Google Cloud Storage (GCS) or Amazon S3

(Automatically enables the Download permission)

nononoyes

Export to webhook2

Export data to webhook endpoints

(Automatically enables the Download permission)

nononoyes
Folders

Create new folders2

Create new personal, workspace, and shared folders

nononoyes

Contribute to shared folders2

Create new documents in workspaces and shared folders

nononoyes

Create new workspace

Create new organization workspaces

(Automatically enables the Contribute to shared folders and Share documents permissions)

nononoyes

1 Access to individual connections are determined by data permissions.

2 Access to individual datasets, data models, and workbooks are determined by folder and document permissions.

3 For a comprehensive comparison of user capabilities, see Basic explore vs. Full explore.

4 Enables the ability to add and view comments for all license tiers. Also enables screenshot capture and annotation in comments for Essential and Pro licenses only.