Desinstalação do ambiente da Sala Limpa¶

Para desinstalar completamente o ambiente de clean room da sua conta, você deve usar a função ACCOUNTADMIN na conta Snowflake em que o aplicativo de clean room está instalado. Isso excluirá o ambiente de Clean Room de todos os usuários da sua conta, tanto como provedores de clean room quanto como consumidores de clean room.

Para desinstalar o ambiente de Clean Room de sua conta:

1. Exclua todas as salas limpas que você criou como provedor.

2. Desinstale todas as salas limpas que você instalou (em que ingressou) como consumidor.

3. Execute os seguintes comandos de desinstalação.

   Cada instrução SELECT CONCAT gera um ou mais comandos SQL que devem ser executados em uma planilha Snowflake na conta em que você deseja remover o ambiente de Clean Room.

   -- 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. Se você quiser excluir sua organização de Snowflake Data Clean Rooms, entre em contato com o suporte Snowflake.