Snowsight Templates learning environment (Preview)¶

When this behavior change bundle is enabled, the dedicated Snowflake learning environment (SNOWFLAKE_LEARNING) is enabled automatically. This environment is required for Snowsight Templates, which let users interactively explore Snowflake features and use cases through worksheets, notebooks, or Streamlit apps that they can run. Templates come preconfigured with sample data and the necessary permissions.

The SNOWFLAKE_LEARNING environment includes a pre-provisioned role (SNOWFLAKE_LEARNING_ROLE), compute warehouse (SNOWFLAKE_LEARNING_WH), and database (SNOWFLAKE_LEARNING_DB).

To enable the learning environment immediately, use the system function:

SELECT SYSTEM$ENABLE_SNOWFLAKE_LEARNING_ENVIRONMENT();

To opt out of the learning environment before the BCR bundle becomes enabled by default:

SELECT SYSTEM$DISABLE_SNOWFLAKE_LEARNING_ENVIRONMENT();

To disable and drop the learning environment after it is enabled:

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;

To verify the current status of the learning environment for you account:

SHOW PARAMETERS LIKE 'SNOWFLAKE_LEARNING_ENVIRONMENT_OPT_OPTIONS';

For more information, see Templates in Snowsight.

Ref: 1992