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

# Apply data validation to input table columns

> Apply data validation to Sigma input table columns. Restrict entries to predefined dropdown values for consistent text, number, and date data.

Data validation ensures data accuracy and consistency by restricting data entry to a set of specific values. When you apply data validation to an input table column, users can only enter or select one of the predefined values from a dropdown.

> **Info**
>
> Sigma only supports data validation for text, number, and date columns. Data validation doesn’t apply to checkbox data columns because Sigma already restricts the values to true (selected) or false (cleared).

This document explains how to apply data validation to input tables.

## System and user requirements

The ability to apply data validation to input tables requires the following:

* Your organization must be connected to a data platform compatible with input tables. See [Region, warehouse, and feature support](/docs/region-warehouse-and-feature-support).

* You must be granted **Can use** [data permission](/docs/data-permissions-overview) for a connection with write access enabled. *If using an OAuth-enabled connection, see [Configure OAuth with write access](/docs/configure-oauth-with-write-access) for additional requirements.*

* You must be assigned an [account type](/docs/account-type-and-license-overview) with the **Create input tables** and **Create, edit, and publish workbooks** permissions enabled.

* You must be the workbook owner or be granted **Can edit** [workbook permission](/docs/folder-and-document-permissions).

## Apply data validation

1. Click the down arrow (![](https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/caret.svg)) in a column header to open the column menu, then select **Data validation**.
2. In the **Data validation** modal, create a manual list of predefined values, or apply the values from a column in an existing data source or element in the workbook:

   > **Info**
   >
   > You can add up to 100,000 distinct values to the list.
   >
   > When referencing a column that exceeds the limit, Sigma applies an arbitrary subset of 100,000 values.

   * Create a manual list of values:

     1. In the **Value source** dropdown, select **Create manual list**.

     2. In the **Define values** field, enter values that align with the column’s data type.

        > **Tip**
        >
        > Enter individual values, or paste multiple values copied from Sigma or an external source (like a spreadsheet or text document).

     3. Click **Save**.
   * Apply values from a column in an existing data source or element:

     1. In the **Value source** dropdown, select a data source or element.

     2. In the secondary dropdown, select a source column to define the values.

     3. Review the column values, then click **Save** to proceed.

     Sigma checks existing data against the defined values and displays red indicators in cells that contain invalid data.

     ![An input table with data validation applied to the New Location column, showing red indicators in cells containing values like Y and N that don't match the predefined Yes/No list.](https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Workbooks/Input+Tables/Create+and+Manage+Input+Tables/input-tables_configure_data-validation_step-2b.png)
3. To replace invalid data, manually enter valid values, or click the down arrow (![](https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/caret.svg)) in the cell and select a predefined value from the dropdown.