Administrator-owned warehouse for Snowflake Notebooks

Attention

This behavior change is in the 2025_01 bundle.

For the current status of the bundle, refer to Bundle History.

In release 8.26, Snowflake introduced a new default warehouse, SYSTEM$STREAMLIT_NOTEBOOK_WH, as a Snowflake-managed object in customer accounts. With this behavior change, the ownership of this warehouse transitions from system-owned to administrator-owned.

After this change:

  1. The ACCOUNTADMIN role will have the OWNERSHIP privilege on this warehouse.

  2. Users can run Python workloads as well as execute any SQL queries on this warehouse.

  3. The ACCOUNTADMIN role can manage this warehouse and perform operations on it.

  4. In alignment with BCR-1887, the SYSTEM$STREAMLIT_NOTEBOOK_WH warehouse is now available for use by Snowflake Notebooks users.

Ref: 1871

Language: English