Intro to input tables
Input tables are generally available on Snowflake and Databricks connections with write-access enabled.
On Amazon Redshift connections, input tables are in public beta.
When applied to input tables on an Amazon Redshift connection, this documentation describes a public beta feature and is under construction. This documentation should not be considered part of our published documentation until this notice, and the corresponding Beta flag on the feature in Sigma, are removed. As with any beta feature, the feature discussed below is subject to quick, iterative changes. The latest experience in the Sigma service may differ from the contents of this document.
Beta features are subject to the disclaimer on Beta features.
Input tables are dynamic workbook elements that support structured data entry. They allow you to integrate new data points into your analysis and augment existing data from your data platform to facilitate rapid prototyping, advanced modeling, forecasting, what-if analysis, and more—without overwriting source data.
Use input tables as sources for tables, pivot tables, and visualizations, or incorporate the data using lookups and joins. And when you create warehouse views for input tables, you can reuse the manually entered data across your broader data ecosystem.
This document introduces empty, CSV, and linked input tables, which support a variety of use cases for ad hoc data entry. For information about creating and interacting with input tables, see Create new input tables and Edit existing input table columns.
Input tables overview
Input tables enable you to do the following:
- Add new rows (empty and CSV input tables only)
- Add new columns (including data entry, computed, row edit history, and system columns)
- Upload and edit CSV data (max 200 MB, UTF-8 only)
- Input values through keyboard entry
- Paste values from your clipboard:
- On Snowflake or Amazon Redshift connections: Paste values in up to 50,000 cells at once (2,000 rows and 25 columns)
- On Databricks connections: Paste values in up to 12,500 cells at once (500 rows and 25 columns)
- Configure data entry permissions
- Configure data validation
- Protect columns to prevent edits
For information about using this functionality, see Create new input tables and Configure data governance options in input tables.
Empty input tables
Empty input tables are blank tables that support data entry in standalone tables independent of existing data. You can edit data at the cell level and add editable rows and columns to construct your table as you see fit.
CSV input tables
CSV input tables also support data entry in standalone tables; however, they allow you to pre-populate the table with uploaded CSV data (max 200 MB, UTF-8 only). You can then edit the uploaded data at the cell level and add other editable rows and columns to construct your table as you see fit.
Linked input tables
Linked input tables support data entry alongside existing data from other elements in the same workbook.
As a child element, a linked input table includes one or more linked columns that reference data in the parent element. This includes a primary key column containing row identifiers that establish the table’s granularity. You can then add other columns to augment the linked data sourced from the parent element.
To maintain the data relationship between the input table rows and source data in the parent element, the primary key column must reference static values. All other linked columns can reference variable data, which is continually updated in the input table to reflect live data from the source.
Types of input table columns
All input tables support the following types of columns, unless otherwise noted:
| Type | Description | Available columns |
|---|---|---|
| Data entry column | Supports direct user input at the individual cell level | Text, Number, Date, Checkbox |
| Computed column | Generates values based on a user-defined formula or lookup | Calculation, Via lookup |
| Row edit history column | Displays system-generated metadata related to row edits | Last updated at (timestamp), Last updated by (user) |
| System column | Displays system-generated metadata related to table components | Row ID (available for empty or CSV input tables only) |
Frequently asked questions
Can I use input tables with data platform connections other than Snowflake, Databricks, and Amazon Redshift?
Input tables are currently compatible with Snowflake, Databricks, and Amazon Redshift connections only. Sigma plans to add support for BigQuery and Postgres connections.
Can I change the write-to location where input table data is stored?
No. Sigma writes input table data to a predefined schema identified in the connection details (Admin > Connections page).
Can linked input tables overwrite data in existing database tables?
No. Sigma protects the integrity of your existing data and stores input table data in a separate schema and database table. As a result, input tables can never overwrite source data.
Why isn’t there a view of published input tables in the connection panel (in the Sigma interface) that displays all database and schemas associated with my account?
When Sigma writes input table data to your CDW, the corresponding database table is created in a write-to schema not directly accessible from the Sigma interface. To identify the destination schema for input table data, reference the connection details in the Admin > Connections page.
Can I query the input table data from my data platform?
While you cannot query the database table directly, you can create a warehouse view for the input table and query that to retrieve the data stored in in your CDW. This allows you to store and save input tables, or reference them in your SQL FROM clause. For more information, see Create and manage workbook warehouse views.
How long is input table data retained in a database table after I delete it in Sigma?
Sigma doesn’t delete input table data from a connected data platform. To remove input table data, you must delete it directly in the data platform.
Updated 1 day ago