Create a local Sigma table (Beta)

Create a new Sigma table that’s independent of existing data in Sigma or your data platform. You can create an empty table or pre-populate it with data from a CSV upload.

The resulting table is a local Sigma table, available only in the workbook you create it in. Use it to prototype a new data source, store and edit new data, or support an app workflow in that workbook.

This page explains how to create a local Sigma table. To create an organization-wide Sigma table, you can promote a local Sigma table, or you can start from an existing input table or connection table.

Requirements

To create a local Sigma table in a workbook:

• You must be assigned an account type with the Can create, edit, and publish workbooks permission enabled.
  • To create a local Sigma table from a CSV upload, your account type must also have the Upload CSV permission enabled.
• You must be the workbook owner or have Can edit workbook access.
• You must have access to a write-back schema on a connection with write access enabled.

About local Sigma tables

When you create a local Sigma table, Sigma creates a new database table in the selected connection and write-back schema. As the creator, you automatically own the Sigma table (Can own table access), so you can add and remove rows, add columns, edit cell data, set the primary key, and manage table grants.

Because a Sigma table is local to the workbook, it doesn’t appear in the data catalog or search results, and users cannot select it as a data source in other Sigma documents. To make a local table available across your organization, you can promote it, which also allows you to customize the table name, choose the destination schema, and decide which columns to include.

Limitations and considerations

• Sigma tables support text, number, date, and boolean column types. Other column types, such as single-select, multi-select, and file columns, are not supported.
• You can create local Sigma tables in workbooks only. You cannot create them in data models or reports, but you can promote a local Sigma table to use it as a data source in any document type.
• Every local Sigma table includes an Id text column used as the primary key. Sigma populates the column with system-generated key values that uniquely identify each row. You cannot choose the primary key when you create the table, but you can change it afterward. For more information, see Change a Sigma table primary key.

Create an empty local Sigma table

Create a local Sigma table without pre-populated data.

1. Open a workbook draft.

2. In the Add element bar, select Input > Sigma table.

   

3. In the Create Sigma table popover, complete the following:

   1. Select Empty table.

   2. In the dropdown, select the connection Sigma must use to write the data to your data platform. If you select an OAuth connection, you must also choose a write-back schema in the Destination dropdown.

      If there are no Destination options available, you don’t have access to any write-back schemas and cannot create a Sigma table on the selected connection. To request access, contact an administrator.

   3. Click Create table.

      

   Sigma adds an empty Sigma table element to the workbook and creates an underlying database table in your data platform.

Create a local Sigma table from a CSV upload

Create a local Sigma table that’s pre-populated with data from a CSV upload.

1. Open a workbook draft.

2. In the Add element bar, select Input > Sigma table.

   

3. In the Create Sigma table popover, complete the following:

   1. Select Upload CSV.

   2. In the dropdown, select the connection Sigma must use to write the data to your data platform. If you select an OAuth connection, you must also choose a write-back schema in the Destination field.

      If there are no destinations available, you don’t have access to any write-back schemas and cannot create a Sigma table on the selected connection. To request access, contact an administrator.

   3. Click Upload CSV.

      

4. In the Upload CSV modal, complete the following:

   1. Drag and drop a file, or click Browse and choose one from the file picker.
   2. Review the parsed data and any warnings, then update the parsing options and column types if needed. See Parse numbers with separators.
   3. Click Save.

   Sigma adds a Sigma table element populated with the CSV data and creates an underlying database table in your data platform.

Related resources

• Sigma tables overview
• Promote a local Sigma table
• Change a Sigma table primary key
• Edit a Sigma table’s data or schema
• Configure access for Sigma tables