Snowsight templates

概要

Snowsightテンプレート は、Snowflakeの機能とユースケースを探索するためのインタラクティブなウォークスルーをユーザーに提供します。テンプレートは実行可能ファイルワークシート、ノートブック、またはStreamlitアプリとして利用でき、サンプルデータと必要な権限があらかじめ構成されています。

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 way as any other object owned by ACCOUNTADMIN. See Budgetsを使用したクレジット使用状況のモニター for details on monitoring and optimizing warehouse compute costs.

注釈

SNOWFLAKE_LEARNING_WH is owned by the ACCOUNTADMIN role. Standard usage costs apply.

テンプレートには次のような利点があります。

  • 実稼働データに影響を与えることなく、新機能やユースケースを安全に試してみてください。

  • すぐに起動して実行できるサンプルデータが含まれています。

  • 通常5分以内で完了する簡潔な自己完結型のエクスペリエンス。

Snowflake automatically provisions the SNOWFLAKE_LEARNING environment for both new and existing accounts as part of BCR-1992. No action is required to enable it.

If your organization prefers not to include this environment, an ACCOUNTADMIN can opt out by running:

SELECT SYSTEM$DISABLE_SNOWFLAKE_LEARNING_ENVIRONMENT();
Copy

If BCR-1992 is not enabled for your account, you can provision the SNOWFLAKE_LEARNING environment manually 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;
Copy

If the SNOWFLAKE_LEARNING environment has already been provisioned in your account, but you want to disable it and drop the objects, a user with the ACCOUNTADMIN role can run the following script to disable and drop the learning environment:

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.com/templates でテンプレートを使い始めましょう。

言語: 日本語