Override the Snowflake warehouse used by a workbook

When you configure a Snowflake connection, you specify a virtual warehouse to use in Snowflake when running queries from Sigma. For a specific workbook, an admin can specify a different virtual warehouse for each Snowflake connection in the workbook. After overriding the warehouse, all queries for all versions of the workbook, including scheduled exports and materializations, use the specified warehouse.

For example, if a few workbooks run complex queries and perform better when run on a large warehouse, you can choose to run only those workbooks on a large warehouse and use a smaller warehouse to run other workbooks. By using a larger warehouse only for the workbooks that need it, you can improve performance of workbooks in Sigma while more closely managing access to and usage of large compute resources.

📘

You cannot override the warehouse for a report or a data model.

Requirements

• You must be assigned the Admin account type and have access to the workbook.

• You must know the name of the Snowflake virtual warehouse that you want to use.

• Users with access to the workbook must have access to use the virtual warehouse in Snowflake:

  • If the Snowflake connection is authenticated with OAuth, all users with access to the workbook must be assigned a role granted the USAGE privilege on the selected override warehouse.
  • If the Snowflake connection is authenticated with key pair, the role or roles associated with the connection must be granted the USAGE privilege on the selected override warehouse.

  If a user does not have a role that allows them to run queries on the warehouse, the user might see errors when accessing data in the workbook.

Change the Snowflake warehouse used by a workbook

To override the default warehouse on the connection and change the Snowflake warehouse used by a workbook, do the following:

1. In the document header, next to the refresh data button, click More options ().
2. Select Override Snowflake warehouses.
3. In the Override Snowflake warehouses modal, review each Snowflake connection and the warehouse set as the default for the connection.
4. For each connection, select the the virtual warehouse in Snowflake that you want to use instead of the default.
5. Click Save.

After saving, all queries run from the workbook, including scheduled exports and materializations, use the specified warehouse. If the workbook has tagged versions, the tagged versions also use the override warehouse.

If the data source with a warehouse override is changed, such as by changing or swapping the source in the workbook, the warehouse override is removed and must be reapplied to the new source, if relevant.