Question 123 - ARA-C01 discussion

Data sharing is a feature that allows Snowflake accounts to share data with each other without the need for data movement or copying1.Data sharing is enabled by creating shares, which are collections of database objects (tables, views, secure views, and secure UDFs) that can be accessed by other accounts, called consumers2.

By default, Snowflake does not allow sharing data from a Business Critical edition account to a non-Business Critical edition account.This is because Business Critical edition offers higher levels of data protection and encryption than other editions, and sharing data with lower editions may compromise the security and compliance of the data3.

However, Snowflake provides the OVERRIDE SHARE RESTRICTIONS global privilege, which allows a user to override the default restriction and share data from a Business Critical edition account to a non-Business Critical edition account.This privilege is granted to the ACCOUNTADMIN role by default, and can be granted to other roles as well4.

To enable data sharing from a Business Critical edition account to an Enterprise edition account, the following steps are required34:

A user in the provider account with the OVERRIDE SHARE RESTRICTIONS privilege must create or alter a share and add the Enterprise edition account as a consumer. The user must also set the share_restrictions parameter to False when adding the consumer. This parameter indicates whether the share is restricted to Business Critical edition accounts only. Setting it to False allows the share to be imported by lower edition accounts.

A user in the consumer account with the IMPORT SHARE privilege must import the share and grant access to the share objects to other roles in the account. The user must also set the share_restrictions parameter to False when importing the share. This parameter indicates whether the consumer account accepts shares from Business Critical edition accounts only. Setting it to False allows the consumer account to import shares from lower edition accounts.

1: Introduction to Secure Data Sharing | Snowflake Documentation

2: Creating Secure Data Shares | Snowflake Documentation

3: Enable Data Share:Business Critical Account to Lower Edition | Medium

4: Enabling sharing from a Business critical account to a non-business ... | Snowflake Documentation