> 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.

# Create and manage datasets (Deprecated)

> If you want to model your data in Sigma, you can create a dataset.

[Datasets](/docs/datasets) are deprecated:

* Starting June 2, 2026, you will no longer be able to create datasets or edit existing datasets.
* Starting September 15, 2026, you will no longer be able to use datasets as a data source or view datasets in Sigma.

Migrate your datasets to data models and update any documents that use datasets as a data source to use a different source. See [Migrate a dataset to a data model](/docs/migrate-a-dataset-to-a-data-model).

If you want to model your data in Sigma, you can create a dataset. Creating a dataset allows you to bundle formulas, data transformations, filters, groupings, and parameters into a rich data source that others can build on. You can also [materialize datasets](/docs/schedule-materialization-for-a-dataset), helping accelerate data analysis.

You can create a dataset from a table in your data platform, from a CSV file, or from a custom SQL statement:

* [Create a dataset from a table](#create-a-dataset-from-a-table)
* [Create a dataset from a CSV file](/docs/using-csvs-in-datasets)
* [Create a dataset from SQL](/docs/create-a-dataset-from-sql)

## User requirements

To create and manage datasets, you must be assigned an [account type](/docs/account-type-and-license-overview) with the **Create, edit, and publish data models** permission enabled.

## Create a dataset from a table

To create a dataset from a table in a connected data source:

1. From **Sigma Home**, select **Connections** to open the list of connected data sources.
2. Select the data connection with the data catalog that you want to view.
3. In the left navigation panel, search or browse the data catalog to locate the table.
4. Select the table name to open the table.

   ![Data catalog for the connected data source, with an EVENTS table selected.](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/564419226db266cb04b74be46b9d6a1b605201c872979d9dd5a16b1de140e7ad/assets/docs-images/563a7477ed80e266ea5e279dd44c75a7901a1106c90c80eb74734bdeb270f6bf-view-data-catalog.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20260725%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20260725T083826Z&X-Amz-Expires=604800&X-Amz-Signature=b7dde9f3aeff61cac4d5110e2a0e20a8b868a88df07330e3a41d823349d53a18&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)
5. Next to **Explore**, select the caret (<img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/caret.svg" alt="" />) to **Use this table**, then choose **Create Dataset**.
6. Name the dataset and choose a location in which to save it, then click **Create**.

## Modify dataset metadata

You can modify the metadata of the dataset, adding a description with usage guidance, provide documentation for specific columns, or apply a badge, for example, to label the dataset contents as high quality, deprecated, or irrelevant.

### Add a dataset description

To add a description to the dataset:

1. Open the dataset, then select **Edit**.
2. Next to the dataset name, select **More info** (<img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/info-circle-filled.svg" alt="" />).
3. In the **Description** field, enter a description for the dataset.
4. To save the description, publish the dataset.

### Add or update a dataset badge

Add or update a certification badge to indicate the status, quality, and reliability of the data.

1. Open the dataset.

2. In the header, select **More info** (<img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/info-circle-filled.svg" alt="" />).

3. In the popover, select an option from the **Badge** dropdown.

   ![More info for a sales targets dataset, with badge drop down open showing available badges of endorsed, deprecated, and warning.](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/ace24d2fc4a74ca4d47d3a9d646dd9d7852b8226e37bcd2418f9002fd9bbb24a/assets/docs-images/cd187ccbc76e4fecde9d0f17612432daf3ba0914f9c0f0e934d2dc34511a83b8-2025-02-13_23-25-54.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20260725%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20260725T083826Z&X-Amz-Expires=604800&X-Amz-Signature=9335ff698ae5c3b001df7bac2ff6feba3c5a5cddafaeb47a37586ebbc46410a3&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)

4. (Optional) When you select a badge, the popover displays the **Badge note** field. Add a note to provide context about the badge.

   ![More info for the sales targets dataset, with a badge note providing context that the data is verified and authorized for use, accompanying the endorsed badge.](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/f1d5bd81e84e39a8923eec6dab587ad827c8f65afad08a4a4b2cdc3718ca8c5a/assets/docs-images/5aac68f70f462ac91619f31e45d2721631771954fddde7e459a7261799826075-2025-02-13_23-33-20.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20260725%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20260725T083826Z&X-Amz-Expires=604800&X-Amz-Signature=7421a3b1a91001d3c187220903f4254acaf7edc7b5855a6abb3254158481838f&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)

   The badge is automatically saved and immediately reflected in the dataset header.

![Dataset header displaying the endorsed badge next to the dataset name.](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/7e384aafe8be06c233ea2455d0f5c08321e40db5e05f740a9bfb5293503cbd10/assets/docs-images/f58ae3ac97e5a41634693591d4c86aee2f3ff6f2c16ffe8707a15accda535b95-2025-02-13_23-28-42.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20260725%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20260725T083826Z&X-Amz-Expires=604800&X-Amz-Signature=783927eec2acbe283376ac7c6b520e5f32bede32e1ddbb1812655e1258102a4d&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)

## Delete a dataset

To delete a dataset you must be the owner of the dataset, have **Can edit** access to the dataset, or be assigned the **Admin** account type.

1. Next to the dataset name, click the caret (<img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/caret.svg" alt="" />), then click **Delete...**.
2. On the **Confirm Deletion** modal, click **Delete**.

### Recover a deleted dataset

To recover a dataset that has been deleted, you must be the owner of the dataset or have the **Admin** account type.

1. Go to your <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/home.svg" alt="" /> **Home** page.
2. In the navigation menu, select <img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/trash-fill.svg" alt="" /> **Trash**.
3. In the **Trash** page, search the list of deleted documents and click the one you want to recover. You can sort the **Name**, **Deleted on**, or **Deleted by** columns to help identify the applicable document.
4. In the **Document has been deleted** modal, click **Recover**. Sigma immediately opens the recovered document.