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.

Summary of Content

Requirements
Configure Write Access in Sigma
Snowflake
BigQuery
Postgres
Redshift

Requirements

  • You must be an Admin to enable this feature.
  • You must have appropriate permissions for your CDW (or a co-worker who can assist you).
  • OAuth must NOT be enabled for your organization.

Configure Write Access in Sigma

  1. Open your Admin Portal by selecting Administration in the user menu at the top right of your screen.

  2. Select the Connections page from the left hand panel.

  3. Click on your connection in the list to view the connection.

  4. Click the Edit button.

  5. Under Connection Features switch on Enable write access.
    Screen_Shot_2020-05-14_at_2.43.26_PM.png

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

  7.  After completing the form, click Save.

Snowflake

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:

grant usage, create table, create view, create stage on schema <YOUR_SCHEMA> to role <YOUR_SIGMA_ROLE>;

BigQuery

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.

Postgres

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.

Redshift

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.

Note: The Database or Database/Schema destination configured for write access, by design will not be available in the Sigma connection explorer pane. We highly recommend configuring a separate DB or DB/Schema from the rest of the data for write-access purposes.