Snowflake Data Clean Rooms 에서 클라우드 간 자동 복제 관리하기¶

Account administrator actions¶

To enable Cross-Cloud Auto-Fulfillment for an account using the API, administrators in both the provider and consumer accounts must run the following SQL code using the ACCOUNTADMIN role. You need to run this only once per account.

USE ROLE ACCOUNTADMIN;
-- Optionally check first to see if LAF is enabled on the account.
CALL samooha_by_snowflake_local_db.library.is_laf_enabled_on_account();

-- If LAF is not enabled, enable it.
CALL samooha_by_snowflake_local_db.library.enable_laf_on_account();

Provider and consumer actions¶

계정에 대해 클라우드 간 자동 복제가 활성화된 후 클린룸을 만들거나 설치할 때 클라우드 간 자동 복제를 활성화하는 방법은 다음과 같습니다.

1. **공급자**는 ``provider.create_or_update_cleanroom_listing``을 호출하여 일반적인 방식으로 클린룸을 게시합니다.

2. 컨슈머 는 ``consumer.install_cleanroom``을 호출하여 클린룸을 설치합니다. 컨슈머가 공급자와 다른 클라우드 리전에 있는 경우, ``consumer.install_cleanroom``이 클라우드 간 자동 복제의 복제가 설치되고 있다는 메시지와 함께 실패합니다.

3. **컨슈머**는 성공을 반환할 때까지 ``consumer.install_cleanroom``을 계속 호출합니다. 설치에는 몇 분이 걸립니다.

   At this point, the consumer has basic clean room functionality. To support client custom template requests, provider-run analyses, and provider activation, follow this additional step:

4. The provider calls provider.mount_request_logs_for_all_consumers until the procedure reports success. This means that communication from the consumer to the provider is enabled.

전체 설정 코드 예:

1. 공급자: 공급자는 표준 방식으로 Clean Room을 생성, 공유 및 게시합니다.

   USE WAREHOUSE APP_WH;
   USE ROLE SAMOOHA_APP_ROLE;
   
   SET cleanroom_name = 'LAF example';
   SET consumer_locator = '<CONSUMER_LOCATOR>';
   SET consumer_account_name = '<CONSUMER_DATA_SHARING_ACCOUNT_ID>';
   
   CALL SAMOOHA_BY_SNOWFLAKE_LOCAL_DB.provider.cleanroom_init($cleanroom_name);
   
   CALL SAMOOHA_BY_SNOWFLAKE_LOCAL_DB.provider.set_default_release_directive(
     $cleanroom_name,
     'V1_0', '0');
   
   CALL SAMOOHA_BY_SNOWFLAKE_LOCAL_DB.provider.add_consumers(
     $cleanroom_name,
     $consumer_locator,
     $consumer_account_name);
   
   CALL SAMOOHA_BY_SNOWFLAKE_LOCAL_DB.provider.create_or_update_cleanroom_listing($cleanroom_name);
   

   Copy

2. 컨슈머: 컨슈머가 클린룸을 설치합니다.

   USE WAREHOUSE APP_WH;
   USE ROLE SAMOOHA_APP_ROLE;
   
   SET cleanroom_name = 'LAF example';
   SET provider_locator = '<PROVIDER_LOCATOR>';
   
   -- Initial call starts the process and returns a cross-cloud/region replication failure.
   -- Continue to call this procedure until it returns a success message.
   CALL SAMOOHA_BY_SNOWFLAKE_LOCAL_DB.consumer.install_cleanroom(
     $cleanroom_name,
     $provider_locator);
   
   -- Continue with standard clean room configuration and use.
   -- The consumer can run analyses, but client custom templates, provider run, and provider analysis
   -- aren't supported until the provider takes the action shown in the next step.
   ...
   

   Copy

3. Provider: After the consumer installs the clean room, the provider must mount the requests share to enable request-based actions between the provider and consumer. Request-based actions include provider requests to run an analysis and consumer requests to add a template to the clean room.

   -- Call mount_request_logs_for_all_consumers until it reports success.
   provider.mount_request_logs_for_all_consumers($cleanroom_name);
   

   Copy

   이제 전체 공급자/컨슈머 기능을 사용할 수 있습니다.