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

# Set up write access

> Set up write access on Sigma connections to enable input tables, warehouse views, materializations, CSV uploads, and running Python code.

Set up write access to enable the use of features like [input tables](/docs/intro-to-input-tables), [warehouse views](/docs/create-and-manage-workbook-warehouse-views), [materialization](/docs/materialization), and [CSV upload](/docs/upload-csv-data).

If your organization uses OAuth to authenticate your connection, there are additional configuration steps. See [Configure OAuth with write access](/docs/configure-oauth-with-write-access).

## System and user requirements

* You must be assigned the **Admin** [account type](/docs/account-type-and-license-overview).
* You must have the necessary permissions in your cloud data warehouse (CDW) to create a write access destination and configure permissions.

## Set up destinations and permissions for write access in your data platform

To set up write access, ensure that Sigma has sufficient permissions in your data platform.

Each CDW has a unique database structure and permissions model. Follow the documentation for your CDW to create a destination that Sigma can use to write data back to, and apply the necessary permissions to allow Sigma to perform write back using the authentication you have configured.

When you designate a schema as the write access destination, Sigma reserves it for internal write-back objects and doesn’t expose it as a data source in the connection explorer (data catalog). To avoid restricting user access to analytical data, use a dedicated write-back database or schema that doesn’t store data used for analysis and reports.

## Configure write access in Sigma

1. Select **Administration** in the user menu at the top right of your screen.

2. Select **Connections** from the left panel.

3. To view the connection, select an existing connection in the list.

4. Click **Edit**.

5. Under **Write access**, turn on the **Enable write access** toggle.

6. Setting up write access involves configuration requirements specific to your data platform, detailed in the following documentation:

   * [AlloyDB](/docs/connect-to-alloydb)
   * [BigQuery](/docs/connect-to-bigquery)
   * [Databricks](/docs/connect-to-databricks#configure-write-access)
   * [MySQL](/docs/connect-to-mysql)
   * [PostgreSQL](/docs/connect-to-postgresql)
   * [Redshift](/docs/connect-to-redshift)
   * [Snowflake](/docs/connect-to-snowflake#configure-write-access)

7. After completing the form, click **Save**.