Workbook Export to Cloud Storage (Beta)

Sigma workbooks can be exported to Google Cloud Storage (GCS) or Amazon S3 from Snowflake connections. 

Cloud storage is particularly useful for large multi-GB data exports. These exports are sent from Sigma to your cloud storage bucket as a single file and can be accessed similarly to other exports. 

This feature is currently in beta. Beta features are subject to quick, iterative changes. As a result, this document may not reflect the most current version.

Summary of Content

Requirements
Supported File Types & Export Limits
Configure Cloud Storage
Format a Destination URI
      Example URI
Send a Single Export
Create an Export Schedule
Related Resources

Requirements

  • You must be an organization Admin or be assigned a custom account type with the appropriate permissions
  • You must have a Snowflake connection
  • If your connected Snowflake database is not already configured for cloud storage exports, you will need at least CREATE INTEGRATION privileges to create a storage integration. Learn more

Supported File Types & Export Limits

Supported file types: CSV

GZIP compressions: supported

Export limit: 5 GB

Configure Cloud Storage

Before you can export workbooks to cloud storage, you will need to set up your storage environment and identify the values required for Sigma to successfully export your data to your target storage bucket.

This can be done through a Snowflake Storage Integration. Please follow Snowflake’s instructions to create your storage integration.

Sigma will ask for the storage integration’s name.

Format a Destination URI

A URI represents your export’s target file path in your cloud storage provider. 

The following template can be used to format your URI:

<schema>://<bucket>/<filepath>/<filename><filetype><compression>

Schema: “s3” if exporting to S3 or “gcs” if exporting to GCS

Bucket: the highest level storage object supported by cloud storage provider; can be thought of as a root folder 

File Path (optional): target subdirectories in the bucket. If this value is excluded, your files will be added directly to the root of your bucket. 

File Type:  “.csv”

Compression (optional): can only be “.gz” 

Example URI

s3://my-sigma-bucket/cloud-exports/sales.csv.gz

Note: If your URI is identical to an existing file in the bucket, it will be overwritten.

Send a Single Export

  1. Click the caret (▼) button next to the workbook title.
  2. Select Send now from the menu.
    Screen_Shot_2022-05-12_at_10.20.36_AM.png
    This will open the Send Now modal.
  3. Under Destination, select Cloud Storage.
    Screen_Shot_2022-05-12_at_10.22.09_AM.png
  4. Under Storage Integration, enter the name of your Snowflake Storage Integration. Learn more
    Screen_Shot_2022-05-12_at_10.25.12_AM.png
  5. Under Destination Cloud Storage URI, enter your target URI. Learn more
    Screen_Shot_2022-05-12_at_10.26.41_AM.png
  6. Select an Element.
    Screen_Shot_2022-05-12_at_10.28.02_AM.png
  7. Select a Format: CSV or CSV, gzipped.
    Screen_Shot_2022-05-12_at_10.28.58_AM.png
  8. Click Send.
    An export confirmation will be sent to your email.

Create an Export Schedule

  1. Click the caret (▼) button next to the workbook title.
  2. Select Schedule exports.
    Screen_Shot_2022-05-12_at_10.30.04_AM.png
    This opens the Schedule Exports modal.
  3. If this is the workbook's first schedule, click Add Schedule.
    Screen_Shot_2022-05-12_at_10.33.05_AM.png
    If one or more schedules already exist, click + New Schedule.
    Screen_Shot_2022-05-12_at_10.33.51_AM.png
    The New schedule dialog will appear.
  4. Under Destination, select Cloud Export.
    Screen_Shot_2022-05-12_at_10.34.47_AM.png
  5. Under Storage Integration, enter the name of your Snowflake Storage Integration. Learn more
    Screen_Shot_2022-05-12_at_10.36.32_AM.png
  6. Under Destination Cloud Storage URI, enter your target URI. Learn more
    Screen_Shot_2022-05-12_at_10.37.54_AM.png
  7. Select an Element.
    Screen_Shot_2022-05-12_at_10.39.16_AM.png
  8. Selecta Format: CSV or CSV, gzipped.
    Screen_Shot_2022-05-12_at_10.39.55_AM.png
  9. [optional] Select Prefix filename with the current date. If this option is not selected, the URI targeted filewill be rewritten to the newest version on each scheduled export.
    Screen_Shot_2022-05-12_at_10.40.43_AM.png
  10. Under Repeat by, select a schedule.
    Screen_Shot_2022-05-12_at_10.42.13_AM.png
  11. [optional] Under Controls, click the + Select Control button to begin applying workbook control values to your scheduled report. Learn more
    Screen_Shot_2022-05-12_at_10.43.10_AM.png
  12. [optional] Under Send, select your preferred send conditions. Learn more
    Screen_Shot_2022-05-12_at_10.44.01_AM.png
  13. Click Create Schedule.

Related Resources

Send or Schedule Workbooks
Connect to Snowflake