Set up write access
Set up write access to enable the use of features like input tables, warehouse views, materialization, and CSV upload. For a video walkthrough, see Video: Set up write access.
If your organization uses OAuth to authenticate your connection, there are additional configuration steps. See Configure OAuth with write access.
System and user requirements
- You must be assigned the Admin account type.
- 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.
How changing the write destination affects existing input tables
Changing a write destination on a connection affects input tables differently depending on the connection’s authentication type. In both cases, however, the change does not move existing input table data already written to your data platform.
- On an OAuth connection, a new write destination only applies to new input tables created after the change. Each existing input table, created before the change, continues to read from and write to the destination assigned when it was created.
- On a non-OAuth connection, a new write destination applies to new and existing input tables. Each input table reads and writes data using the new write destination, but data written to the data platform before the change stays in the previous destination. As a result, queries on existing input tables look for data in the new destination but can fail because the data is not stored there. To troubleshoot this error, contact Support.
Configure write access in Sigma
-
Select Administration in the user menu at the top right of your screen.
-
Select Connections from the left panel.
-
To view the connection, select an existing connection in the list.
-
Click Edit.
-
Under Write access, turn on the Enable write access toggle.
-
Setting up write access involves configuration requirements specific to your data platform, detailed in the following documentation:
-
After completing the form, click Save.
Video: Set up write access
To watch a guided walkthrough of setting up write access on a Snowflake connection, view the video below. The same steps apply to other connections that support write access.