Snowflake Notification: Provisioning the Snowflake Learning role, warehouse, & database

3 views

Skip to first unread message

Snowflake Global Technical Support

unread,

Nov 17, 2025, 2:28:08 PM11/17/25

to kito...@googlegroups.com

Dear Snowflake Customer,

Snowflake is sending you this important message regarding an upcoming behavior change that may impact your account. Read below for more details:

Why we’re contacting you:
You are receiving this email because Snowflake is introducing a feature in an unbundled BCR (2159) and your account may be impacted by this change. This change is expected to be deployed during the windows, December 2 to December 17, 2025 and January 7 to January 16, 2026. Note that dates are subject to change.

For more information on how you can manage behavior changes in your environment, review the Behavior Change Policy.

What is changing?
As part of this change, Snowflake will create a warehouse (SNOWFLAKE_LEARNING_WH), database (SNOWFLAKE_LEARNING_DB), and role (SNOWFLAKE_LEARNING_ROLE) granted to PUBLIC in your account. These resources enable users to run Snowflake Templates which provide users with interactive walkthroughs for exploring Snowflake features and use cases. Once created, these resources will be owned by ACCOUNTADMIN.

The warehouse, database, and role are created using the following SQL:

CREATE DATABASE SNOWFLAKE_LEARNING_DB;

CREATE ROLE SNOWFLAKE_LEARNING_ROLE;

GRANT ROLE SNOWFLAKE_LEARNING_ROLE TO ROLE PUBLIC;

CREATE WAREHOUSE SNOWFLAKE_LEARNING_WH

COMMENT = 'Warehouse used for executing template and demo content'

WAREHOUSE_SIZE = 'X-Small'

AUTO_RESUME = true

AUTO_SUSPEND = 300;

GRANT USAGE, MONITOR, OPERATE ON WAREHOUSE SNOWFLAKE_LEARNING_WH TO ROLE SNOWFLAKE_LEARNING_ROLE;

GRANT USAGE ON DATABASE SNOWFLAKE_LEARNING_DB TO ROLE SNOWFLAKE_LEARNING_ROLE;

GRANT CREATE SCHEMA ON DATABASE SNOWFLAKE_LEARNING_DB TO ROLE SNOWFLAKE_LEARNING_ROLE;

Behavior before the bundle is enabled on the account

Behavior after the bundle is enabled on the account

SNOWFLAKE_LEARNING_WH, SNOWFLAKE_LEARNING_DB, and SNOWFLAKE_LEARNING_ROLE are not present, and users are not able to run Snowflake Templates.

SNOWFLAKE_LEARNING_WH, SNOWFLAKE_LEARNING_DB, and SNOWFLAKE_LEARNING_ROLE are automatically created, allowing users to run Snowflake Templates to learn about new features and use cases.

Template Hub (https://app.snowflake.com/templates) will be available to the customer and can be accessed via Projects -> Templates.

Key benefit(s):
Users can more easily discover, evaluate, and try new features and use cases, upleveling their skill in Snowflake using sample data and curated templates.

Why are we making this change?
To streamline user education and feature discovery by providing a ready-to-use environment that reduces time to value and setup complexity.

What you need to do:
No action is required to receive this functionality. The Snowflake Learning Environment will be enabled automatically after the bundle is enabled. If the Snowflake Learning Environment is already provisioned to your account, no changes will be made in this BCR.

If you prefer not to use this environment, an ACCOUNTADMIN may opt out with the system function prior to the BCR rollout:

SELECT SYSTEM$DISABLE_SNOWFLAKE_LEARNING_ENVIRONMENT();

To enable the learning environment immediately, run the following SQL:

USE ROLE ACCOUNTADMIN;

CREATE DATABASE SNOWFLAKE_LEARNING_DB;

CREATE ROLE SNOWFLAKE_LEARNING_ROLE;

GRANT ROLE SNOWFLAKE_LEARNING_ROLE TO ROLE PUBLIC;

CREATE WAREHOUSE SNOWFLAKE_LEARNING_WH

COMMENT = 'Warehouse used for executing template and demo content'

WAREHOUSE_SIZE = 'X-Small'

AUTO_RESUME = true

AUTO_SUSPEND = 300;

GRANT USAGE, MONITOR, OPERATE ON WAREHOUSE SNOWFLAKE_LEARNING_WH TO ROLE SNOWFLAKE_LEARNING_ROLE;

GRANT USAGE ON DATABASE SNOWFLAKE_LEARNING_DB TO ROLE SNOWFLAKE_LEARNING_ROLE;

GRANT CREATE SCHEMA ON DATABASE SNOWFLAKE_LEARNING_DB TO ROLE SNOWFLAKE_LEARNING_ROLE;

To disable and drop the Snowflake Learning Environment after it has been created, use the following SQL:

USE ROLE ACCOUNTADMIN;

SELECT SYSTEM$DISABLE_SNOWFLAKE_LEARNING_ENVIRONMENT();

-- DATABASE

SHOW DATABASES LIKE 'SNOWFLAKE_LEARNING_DB';

DROP DATABASE SNOWFLAKE_LEARNING_DB;

-- WAREHOUSE

SHOW WAREHOUSES LIKE 'SNOWFLAKE_LEARNING_WH';

DROP WAREHOUSE SNOWFLAKE_LEARNING_WH;

-- ROLE

SHOW ROLES LIKE 'SNOWFLAKE_LEARNING_ROLE';

DROP ROLE SNOWFLAKE_LEARNING_ROLE;

We’re here to help:
For more details about the Snowflake Learning Environment and templates, see Snowsight Templates.

If you have any questions regarding this change, open a case with our support team and reference BCR-2159

Sincerely,
Snowflake Global Technical Support

To provide the best experience and value to our customers, Snowflake is continually improving and enhancing our service offerings. As part of these ongoing efforts, changes to existing/established product behavior are sometimes required. Please see our behavior change policy to learn more about the process.

You received this email because you were identified as a contact for operational messages related to Snowflake.