Managing Cross-Cloud Auto-Fulfillment in Collaboration Data Clean Rooms¶
About Cross-Cloud Auto-Fulfillment¶
Collaborators can seamlessly share data with collaborators in different cloud regions. In order to do so, they must enable Cross-Cloud Auto-Fulfillment on their account. Only collaborators sharing or activating data must enable this on their account.
When Cross-Cloud Auto-Fulfillment is used in a collaboration:
Data is replicated into the cloud region of each collaborator that can access that data.
Data is also replicated into the owner’s region for orchestration purposes via the Secure Collaboration Orchestrator (SCO). However, the collaboration owner’s ability to access the data is determined by the data offering’s sharing rules.
Collaborators in a different cloud region experience some data lag due to the replication frequency.
Enabling Cross-Cloud Auto-Fulfillment¶
Cross-Cloud Auto-Fulfillment must be enabled in the account of any collaborator that needs to share data with an account in another cloud hosting region. If this feature isn’t enabled for an account or role in an account, follow the below steps:
Enable Cross-Cloud Auto-Fulfillment for an account
To check if Cross-Cloud Auto-Fulfillment is enabled on an account, an organization administrator must call SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT.
To enable Cross-Cloud Auto-Fulfillment on an account, an organization administrator must call SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT.
Enable Cross-Cloud Auto-Fulfillment for a role in an account
To delegate privileges to another role in an account, an ACCOUNTADMIN role can grant the MANAGE LISTING AUTO FULFILLMENT privilege to other roles in the account. For more information, see Manage privileges for auto-fulfillment.
Note
Each user who will call REVIEW or JOIN must have a first and last name set with a validated email address on their Snowflake user profile. See Verify the email addresses of the email notification recipients for instructions.
Refresh frequency for cross-region accounts¶
Update requests and shared data between collaborators in different cloud regions are subject to a 10-minute refresh schedule. This schedule is not configurable.
Costs associated with cross-region collaboration¶
Additional costs are incurred when collaborators are in different cloud regions. For more information about how these costs are incurred, see Auto-fulfillment costs.
Limitations on cross-region collaboration¶
The following limitations exist on cross-region collaboration:
Collaborators can’t link external tables in collaborations. See list of supported objects.
See additional considerations when enabling cross-region collaboration.