Set Up Write Access

Granting Sigma Write access to your database allows you to enable the ability to upload CSVs to analyze in Sigma, and allows Admins to materialize Datasets back to the data warehouse.

Setting up write access requires configuring Sigma and configuring your data warehouse. You must be a Sigma Admin to enable write access.

Configure Write Access in Sigma

  1. Click on the profile icon on the top right of your screen, and choose settings.
  2. Go to Connections.
  3. Find the connection that you would like to set up write access for.
  4. Click the ‘…’ on the right-hand side and choose ‘Edit Connection’.
  5. Flip the switch to enable Write Access.
  6. Enter the requested information.

Configure Write Access for Your Database

Jump to how to set up write access for:

Snowflake

BigQuery

Postgres

Redshift

 

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

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.

 

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.

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us