Managing Cross-Cloud Auto-Fulfillment in Snowflake Data Clean Rooms¶

1. Navigate to the Snowflake Data Clean Rooms login page.

2. Enter your email address, and select Continue.

3. Enter your password.

4. If you are associated with multiple clean room environments, select the Snowflake account that you are configuring.

5. Select Admin > Snowflake Admin.

6. Select Login to Snowflake, and authenticate as a Snowflake user with the ACCOUNTADMIN role.

7. Toggle on Cross-Cloud Auto-Fulfillment.

8. No additional steps are required by the provider or consumer when creating or joining a clean room.

Administrator

The administrator in both the provider and consumer must enable Cross-Cloud Auto-Fulfillment for their Snowflake account. This can be done either in the clean room UI, or using the following API procedure:

USE ROLE ACCOUNTADMIN;
CALL SAMOOHA_BY_SNOWFLAKE_LOCAL_DB.library.enable_laf_on_account();

Copy

Provider and consumer

After Cross-Cloud Auto-Fulfillment is enabled for an account, both the provider and consumer must enable Cross-Cloud Auto-Fulfillment for the clean room whenever they create or join a clean room across cloud regions.

For basic clean room usage, the consumer needs to call only consumer.request_laf_cleanroom.

To support full functionality described below, both sides must take these additional steps:

1. The consumer calls consumer.setup_cleanroom_request_share_for_laf.

2. The provider then calls provider.request_laf_cleanroom_requests and provider.mount_laf_cleanroom_requests_share.

3. For provider activation, the consumer calls consumer.setup_activation_share_to_laf_consumer.

When full setup is complete, the following additional functionality can be implemented the same way as same-region collaborators:

• Request logging

• Client template requests

• Provider-run analyses

• Provider activation

Full setup example:

1. Provider: The provider creates, shares, and publishes a clean room in the standard way.

   USE ROLE SAMOOHA_APP_ROLE;
   USE WAREHOUSE APP_WH;
   
   SET cleanroom_name = 'LAF example';
   CALL SAMOOHA_BY_SNOWFLAKE_LOCAL_DB.provider.cleanroom_init($cleanroom_name);
   CALL samooha_by_snowflake_local_db.provider.link_datasets($cleanroom_name,
     ['SAMOOHA_SAMPLE_DATABASE.DEMO.CUSTOMERS']);
   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. Consumer: The consumer installs the clean room and sets up full functionality for a cross-region clean room.

   -- Async request to set up Cross-Cloud Auto-Fulfillment.
   -- This must be done before installing the clean room.
   -- Continue calling until it returns status FULFILLED. This can take 10 minutes.
   CALL SAMOOHA_BY_SNOWFLAKE_LOCAL_DB.consumer.request_laf_cleanroom(
     $cleanroom_name,$provider_locator);
   
   -- Consumer can now install and use the clean room in a limited fashion.
   -- However, if they want full functionality they must take the following steps.
   CALL SAMOOHA_BY_SNOWFLAKE_LOCAL_DB.consumer.install_cleanroom(
     $cleanroom_name, $provider_locator);
   
   -- Set up cross-region sharing.
   CALL SAMOOHA_BY_SNOWFLAKE_LOCAL_DB.consumer.setup_cleanroom_request_share_for_laf(
     $cleanroom_name, $provider_data_sharing_account_locator);
   
   -- Continue with clean room configuration, but don't use full functionality until
   -- the provider has completed the next section.
   

   Copy

3. Provider: After the consumer has set cross-region functionality for the clean room, the provider must set it up on their end.

   USE ROLE SAMOOHA_APP_ROLE;
   -- Call request_laf_cleanroom_requests until it reports the status as FULFILLED,
   -- then call mount_laf_cleanroom_requests_share. These steps can take 10 minutes
   -- or more to complete.
   CALL samooha_by_snowflake_local_db.provider.request_laf_cleanroom_requests(
     $cleanroom_name, $consumer_locator);
   CALL samooha_by_snowflake_local_db.provider.mount_laf_cleanroom_requests_share(
     $cleanroom_name, $consumer_locator);
   

   Copy

Full functionality is now available.