卸载 Clean Room 环境¶

要从账户中完全卸载 Clean Room 环境，必须使用已安装 Clean Room 应用程序的 Snowflake 账户中的 ACCOUNTADMIN 角色。这将删除账户中所有用户（无论是 Clean Room 提供商还是 Clean Room 使用者）的 Clean Room 环境。

要为您的账户卸载 Clean Room 环境，请执行以下操作：

1. 删除您作为提供商创建的所有 Clean Room。

2. 卸载您作为使用者安装（联接）的所有 Clean Room。

3. 运行以下卸载命令。

   每条 SELECT CONCAT 语句都会生成一个或多个 SQL 命令，您应在要移除 Clean Room 环境的账户的 Snowflake 工作表中运行这些命令。

   -- Drop created and installed (joined) clean rooms, if you have not done so.
   
   USE ROLE ACCOUNTADMIN;
   
   -- 1: Drop listings --
   -- 1.1 Generate the SQL commands:
   SHOW listings;
   WITH listings AS (
       SELECT * FROM TABLE(result_scan(last_query_id()))
       WHERE "name" ilike 'SAMOOHA^_CLEANROOM^_%' ESCAPE '^'
   ),
   alter_n_drop_listings AS (
       SELECT 'ALTER LISTING ' || "name" || ' UNPUBLISH;DROP LISTING ' || "name" || ';'
       FROM listings WHERE "state" = 'PUBLISHED'
   ),
   drop_listings AS (
       SELECT 'DROP LISTING ' || "name" || ';'
       FROM listings WHERE "state" = 'UNPUBLISHED'
   )
   SELECT * FROM alter_n_drop_listings
   UNION ALL
   SELECT * FROM drop_listings;
   
   -- 1.2 Run the ALTER LISTING commands generated by the previous SELECT statement.
   
   -- 2: Drop shares --
   -- 2.1 Generate the SQL commands:
   SHOW SHARES;
   SELECT CONCAT('DROP SHARE ', "name", ';')
     FROM TABLE(RESULT_SCAN(last_query_id()))
     WHERE "kind" = 'OUTBOUND'
       AND "name" LIKE 'SAMOOHA_CLEANROOM_%';
   
   -- 2.2 Run the DROP SHARE commands generated by the previous SELECT statement.
   
   -- These shares have to be dropped manually:
   DROP SHARE SAMOOHA_INTERNAL_GOVERNANCE_SUMMARY_SHARE_NAV2;
   DROP SHARE SAMOOHA_INTERNAL_LOGS_SHARE_NAV2;
   DROP SHARE SAMOOHA_INTERNAL_PROVIDER_METADATA_NAV2;
   
   -- Needed only for accounts that enabled Cross-Cloud Auto-Fulfillment
   DROP SHARE SAMOOHA_INTERNAL_GOVERNANCE_SUMMARY_SHARE_NAV2_LAF;
   
   -- 3: Drop applications --
   -- 3.1 Generate the SQL commands:
   SHOW APPLICATIONS;
   SELECT CONCAT('DROP APPLICATION ', "name", ' CASCADE;')
     FROM TABLE(RESULT_SCAN(last_query_id()))
     WHERE "name" LIKE 'SAMOOHA_CLEANROOM_APP_%';
   
   -- 3.2 Run the DROP APPLICATION commands generated by the previous SELECT statement.
   
   -- 4: Drop application packages --
   -- 4.1 Generate the SQL commands:
   SHOW APPLICATION PACKAGES;
   SELECT CONCAT('DROP APPLICATION PACKAGE ', "name", ' CASCADE;')
     FROM TABLE(RESULT_SCAN(last_query_id())) WHERE "name" LIKE 'SAMOOHA_CLEANROOM_%';
   
   -- 4.2 Run the DROP APPLICATION PACKAGE commands generated by the previous SELECT statement.
   
   -- 5: Drop databases --
   -- 5.1 Generate the SQL commands:
   SHOW DATABASES;
   SELECT CONCAT('DROP DATABASE ', "name", ';')
     FROM TABLE(RESULT_SCAN(last_query_id()))
     WHERE "name" = 'SAMOOHA_SAMPLE_DATABASE'
       OR "name" LIKE 'SAMOOHA_CLEANROOM_%'
       OR "name" = 'SAMOOHA_BY_SNOWFLAKE_LOCAL_DB'
       OR "name" LIKE 'SAMOOHA_INTERNAL_GOVERNANCE_%'
       AND NOT startswith("name", 'SAMOOHA_CLEANROOM_CONSUMER_');
   
   -- 5.2 Run the DROP DATABASE commands generated by the previous SELECT statement.
   
   -- 6: Drop warehouses --
   -- 6.1 Generate the SQL commands:
   SHOW WAREHOUSES;
   SELECT 'DROP WAREHOUSE IF EXISTS ' || "name" || ';' AS drop_statements
   FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()))
   WHERE "name" LIKE 'APP\_WH%'
     OR "name" LIKE 'DCR\_WH%'
     OR "name" LIKE 'PROVIDER\_RUN\_%'
     OR "name" LIKE 'SAMOOHA_TASK_WAREHOUSE'
   ORDER BY "name";
   
   -- 6.2 Run the DROP WAREHOUSES commands generated by the previous SELECT statement.
   
   -- 7: Finally drop the Snowflake native app
   DROP APPLICATION SAMOOHA_BY_SNOWFLAKE CASCADE;
   

   Copy

4. 如果您想将您的组织从 Snowflake Data Clean Room 中删除，请联系 Snowflake 支持部门。