Granting write access to your database enables the use of several Sigma features:
Setting up write access requires configuring your connection settings in Sigma and configuring Sigma's permissions in your data warehouse. You must be a Sigma Admin to enable write access.
Configure Write Access in Sigma
- Open your Admin Portal by selecting ‘Administration’ in the user menu at the top right of your screen.
- Select the ‘Connections’ page from the left hand panel.
- Click on your connection in the list to view the connection.
- Click the 'Edit' button.
- Under ‘Connection Features’ switch on ‘Enable write access’.
- At this point, you will be asked for some information about your database. The required input varies depending on your warehouse provider. Select your warehouse from the following list to learn more:
- After completing the form, click 'Save'.
To set up Sigma write access for a Snowflake connection, you need to specify a Database and Schema that you would like Sigma to write back to. The Snowflake user used to connect to Sigma needs to have USAGE permission on the Database, and USAGE, CREATE TABLE, CREATE VIEW and CREATE STAGE permissions on the Schema.
To grant the necessary permissions in Snowflake, open your Snowflake instance and follow the steps below.
Replace YOUR_DATABASE_NAME with the name of your database. Replace YOUR_SCHEMA with the name of the schema you'd like to grant permissions to. Replace YOUR_SIGMA_ROLE with the role you used to connect. If you connected using Snowflake Partner Connect, use PC_SIGMA_ROLE.
Enter the following commands into the SQL editor in the Worksheets tab for the Database you wish to give Sigma access to:
use WAREHOUSE <YOUR_SIGMA_WH>;
use DATABASE <YOUR_DATABASE_NAME>;
grant usage on database <YOUR_DATABASE_NAME> to role <YOUR_SIGMA_ROLE>;
Enter the following command into the SQL editor for the schema you wish to give Sigma access to:
To set up write access for BigQuery, your BigQuery Service account needs to be the Data Owner for the Dataset that you would like Sigma to write back to. Learn how to grant roles to service accounts.
CSV Upload is not supported for Postgres. Setting up write access will allow Admins to materialize Datasets back to the data warehouse.
To set up Sigma write access for a Postgres connection, you need to specify a Schema that you would like Sigma to write back to. The Postgres user used to connect to Sigma needs to be the owner of the Schema, with the ability to create and drop tables.
To set up Sigma write access for a Redshift connection, you need to specify a Schema that you would like Sigma to write back to. The Redshift user used to connect to Sigma needs to be the owner of the Schema, with the ability to create and drop tables.