> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Basic explore vs. Full explore

> Compare Basic explore and Full explore Sigma account type permissions. Control how users with Can explore access interact with workbooks.

[Account types](/docs/account-type-and-license-overview) support two permissions (**Basic explore** and **Full explore**) that enable users to be granted **Can explore** [access to individual workbooks](/docs/folder-and-document-permissions). These account type permissions determine how users interact with workbooks, specifically in **View** and **Explore** mode.

* **Basic explore** enables users to access **View** mode with additional interactions and lightweight customization *when granted **Can explore** access to the workbook*.

* **Full explore** enables **Basic explore** capabilities in **View** mode and the full scope of interactions and customizations in **Explore** mode.

This document provides comprehensive comparisons of granular user capabilities based on account type permission (**View workbooks**, **Basic explore**, or **Full explore**) and workbook access (**Can view** or **Can explore**). For a complete comparison of capabilities in all workbook modes, including **Edit** mode, see [Workbook modes overview](/docs/workbook-modes-overview).

The comparisons include the **View workbook** permission to demonstrate the workbook interactions supported when a user is assigned an account type with neither **Basic explore** nor **Full explore** permission. For more information about these account type permissions, see [License and account type overview](/docs/account-type-and-license-overview).

## **View** mode + **Can view**

The following table lists the baseline interactions enabled in **View** mode *when a user is granted **Can view** workbook access*.

User capabilities are the same whether a user is assigned an account type with **View workbooks**, **Basic explore**, or **Full explore** permission.

|                                   | View workbooks                                                                                              | Basic explore                                                                                               | Full explore                                                                                                |
| :-------------------------------- | :---------------------------------------------------------------------------------------------------------- | :---------------------------------------------------------------------------------------------------------- | :---------------------------------------------------------------------------------------------------------- |
| Update control values             | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| Modify existing filters           | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| Sort column data                  | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| View column details               | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| Expand/collapse grouped rows      | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| View *aggregated* underlying data | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| Refresh data                      | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| Create bookmarks                  | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |

## **View** mode + **Can explore**

The following table lists additional interactions and lightweight customization enabled in **View** mode *when a user is granted **Can explore** workbook access*. All capabilities detailed in the previous section ([View mode + Can view](#view-mode--can-view)) are also supported.

Only users assigned account types with **Basic explore** or **Full explore** permission can be granted **Can explore** workbook permission. Therefore, users assigned account types limited to **View workbooks** permission cannot be granted **Can explore** workbook permission and cannot perform the following interactions.

|                                                           | View workbooks                                                                                          | Basic explore                                                                                               | Full explore                                                                                                |
| :-------------------------------------------------------- | :------------------------------------------------------------------------------------------------------ | :---------------------------------------------------------------------------------------------------------- | :---------------------------------------------------------------------------------------------------------- |
| Create new filters                                        | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| View and drill into *unaggregated* underlying data        | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| Use drill paths ("Drill anywhere")                        | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| Format, reorder, rename, hide, freeze, and delete columns | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| Export to PNG                                             | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| Copy data point values                                    | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| Copy/paste elements                                       | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" />     | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |

## **Explore** mode + **Can explore**

The following table lists the remaining interactions and customizations enabled in **Explore** mode *when a user is granted **Can explore** workbook access*. All capabilities detailed in the previous sections ([View mode + Can view](#view-mode--can-view) and [View mode + Can explore](#view-mode--can-explore)) are also supported.

Only users assigned account types with **Full explore** permission can access **Explore** mode. Therefore, users assigned account types limited to **View workbooks** or **Basic explore** permission cannot access **Explore** mode to perform the following capabilities.

|                                                                                                          | View workbooks                                                                                          | Basic explore                                                                                           | Full explore                                                                                                |
| :------------------------------------------------------------------------------------------------------- | :------------------------------------------------------------------------------------------------------ | :------------------------------------------------------------------------------------------------------ | :---------------------------------------------------------------------------------------------------------- |
| Create, edit, and delete pages                                                                           | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| Create, edit, and delete elements <br />*editing encompasses properties, format, actions, columns, etc.* | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| Duplicate and move existing elements                                                                     | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| View and change element data sources                                                                     | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| Add and modify columns                                                                                   | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| View custom SQL logic                                                                                    | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| Edit layouts and workbook settings                                                                       | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |
| View lineage                                                                                             | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-x-solid.svg" alt="" /> | <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/square-check-solid.svg" alt="" /> |