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
- Click the caret (▼) button next to the workbook title.
- Select Send now from the menu.
This will open the Send Now modal. - Under Destination, select Cloud Storage.
- Under Storage Integration, enter the name of your Snowflake Storage Integration. Learn more
- Under Destination Cloud Storage URI, enter your target URI. Learn more
- Select an Element.
- Select a Format: CSV or CSV, gzipped.
- Click Send.
An export confirmation will be sent to your email.
Create an Export Schedule
- Click the caret (▼) button next to the workbook title.
- Select Schedule exports.
This opens the Schedule Exports modal. - If this is the workbook's first schedule, click Add Schedule.
If one or more schedules already exist, click + New Schedule.
The New schedule dialog will appear. - Under Destination, select Cloud Export.
- Under Storage Integration, enter the name of your Snowflake Storage Integration. Learn more
- Under Destination Cloud Storage URI, enter your target URI. Learn more
- Select an Element.
- Selecta Format: CSV or CSV, gzipped.
- [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.
- Under Repeat by, select a schedule.
- [optional] Under Controls, click the + Select Control button to begin applying workbook control values to your scheduled report. Learn more
- [optional] Under Send, select your preferred send conditions. Learn more
- Click Create Schedule.