Snowsight 中的模板

概述

Snowsight templates provide users with interactive walkthroughs for exploring Snowflake features and use cases. Templates are available as executable worksheets, notebooks, or Streamlit apps, and come pre-configured with sample data and the required permissions.

Templates run in a dedicated SNOWFLAKE_LEARNING environment, which includes a pre-provisioned role (SNOWFLAKE_LEARNING_ROLE), an X-Small compute warehouse (SNOWFLAKE_LEARNING_WH), and a database (SNOWFLAKE_LEARNING_DB). Costs associated with the SNOWFLAKE_LEARNING_WH and SNOWFLAKE_LEARNING_DB are managed in the same as any other object owned by ACCOUNTADMIN. See 通过预算监控 Credit 使用量 for details on monitoring and optimizing warehouse compute costs.

备注

SNOWFLAKE_LEARNING_WH 归 ACCOUNTADMIN 角色所有。

模板具备以下优势：

  • 在不影响生产数据的情况下安全地尝试新功能和新用例。

  • 包含示例数据，可快速启动并运行。

  • 提供简洁、独立的体验，通常可在五分钟内完成。

在 2025 年 5 月 28 日之后创建的试用账户中，SNOWFLAKE_LEARNING 环境是自动预置的。

仓库、数据库和角色使用以下 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;
Copy

对于现有客户账户，SNOWFLAKE_LEARNING 环境需要由具有 ACCOUNTADMIN 角色的用户手动设置。请运行以下 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;
Copy

如果已经预置 SNOWFLAKE_LEARNING 环境，但您想将其禁用并删除对象，则具有 ACCOUNTADMIN 角色的用户可以运行以下脚本来禁用和删除学习环境：

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;
Copy

请访问以下网址，开始使用模板：http://app.snowflake.cn/templates。

语言: 中文