Is it possible for a data provider account with a Snowflake Business Critical edition to share data with an Enterprise edition data consumer account?

Question

Options

• AA Business Critical account cannot be a data sharing provider to an Enterprise consumer. Any
• BIf a user in the provider account with role authority to create or alter share adds an Enterprise
• CIf a user in the provider account with a share owning role sets share_restrictions to False when
• DIf a user in the provider account with a share owning role which also has override share restrictions

• A
  3% (1)
• B
  93% (27)
• C
  3% (1)

Explanation

By default, Snowflake restricts Business Critical edition accounts from sharing data with non-Business Critical accounts (such as Enterprise) to protect sensitive data. However, this restriction can be bypassed. Option B describes the scenario where a user with the appropriate role authority (specifically one that has been granted the OVERRIDE SHARE RESTRICTIONS privilege) adds an Enterprise consumer account to a share, which makes cross-edition sharing possible. Option A is incorrect because the sharing IS possible under the right conditions. Options C and D describe a 'share_restrictions' parameter approach, but the specific mechanism in B-using the OVERRIDE SHARE RESTRICTIONS privilege granted at the account level-is the standard Snowflake mechanism.

No community discussion yet for this question.