Create and Manage Workbook Warehouse Views (Beta)
This feature is currently in Beta and subject to quick, iterative changes. As a result, the latest product version may differ from the content of this document.
Create warehouse views based on data elements and input tables to simplify queries and retrieve relevant and up-to-date subsets of data directly from your database.
Warehouse views are virtual tables in Snowflake that you can query using Sigma or any other application in your data ecosystem. Instead of storing data in a Snowflake database table, a view saves a SQL statement that expresses specific query logic defined by the data element or input table in Sigma.
When you create a warehouse view, you establish a live link between Snowflake and Sigma. The view references the data element or input table as the source of truth and automatically updates to reflect the most recent version of the element’s underlying data.
This document explains how to create and manage workbook warehouse views for data elements and input tables. For information about creating warehouse views for datasets, see Dataset Warehouse Views.
Summary of Content
System and User Requirements
The ability to create and manage a workbook warehouse view requires the following:
- The element’s data source (i.e., dataset or connection table) must retrieve data from a Snowflake connection with Write access enabled.
- You must be assigned an account type with the Create Warehouse View permission enabled.
- You must be the workbook owner or be granted Can edit workbook permission.
Create a View
Warehouse views cannot be created for data elements and input tables impacted by parameters or row-level security. For more information, see Frequently Asked Questions.
- Open a workbook in any mode and locate the element for which you want to create a warehouse view.
- In the element toolbar, click the
action icon to open the element menu, then select Create warehouse view.
Sigma creates warehouse views for elements in published workbooks only. If you’re currently working in an exploration, save it as a workbook before attempting to create a view.
- In the Create Warehouse View modal, Sigma auto-generates a name for the view. Edit the name, if needed, then click Create.
Sigma creates a warehouse view from the latest published element data and automatically updates the view each time the workbook is re-published.
- If the workbook was last published before the element was added, Sigma creates the view when the workbook is re-published and the element data is saved.
- If the workbook was published after the element was added, but the element has unsaved changes, Sigma creates a view for the last published element data.
- If the workbook was published after the element was added, and the element doesn’t have unsaved changes, Sigma creates a view for the element data as you currently see it in the workbook.
- Sigma notifies you when the view is successfully created. You can also preview the status in the element toolbar or click View warehouse view info to see details about the view.
Rename a View
- Open a workbook in any mode and locate the element associated with the warehouse view you want to rename.
- In the element toolbar, click the action icon to open the element menu, then select Manage warehouse view.
- In the Manage Warehouse View modal, enter a new name in the Name field, then click Update.
- Sigma notifies you when the view is successfully updated. You can also preview the status in the element toolbar or click View warehouse view info to see details about the view.
Delete a View
- Open a workbook in any mode and locate the element associated with the warehouse view you want to delete.
- In the element toolbar, click the action icon to open the element menu, then select Manage warehouse view.
- In the Manage Warehouse View modal, click Delete.
- In the Confirm Delete modal, click Delete.