A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition. How can this data be shared?
A.
The healthcare company will need to change the institute’s Snowflake edition in the accounts panel.
B.
By default, sharing is supported from a Business Critical Snowflake edition to a Standard edition.
C.
Contact Snowflake and they will execute the share request for the healthcare company.
D.
Set the share_restriction parameter on the shared object to false.
https://docs.snowflake.com/en/user-guide/override_share_restrictions
For me it looks as D:
-- grant the privilege to the SYSADMIN role
use role accountadmin;
grant override share restrictions on account to role sysadmin;
-- SYSADMIN can now add a consumer account to a share with the SHARE_RESTRICTIONS parameter set to false
use role sysadmin;
alter share <share_name> add accounts = <consumer_account_name> SHARE_RESTRICTIONS=false;
B. By default, sharing is supported from a Business Critical Snowflake edition to a Standard edition.
Snowflake allows data sharing between different editions of accounts, including from higher editions (like Business Critical) to lower editions (like Standard). This means that the healthcare company can share data with the medical institute without needing to change the institute’s Snowflake edition or contact Snowflake for assistance.
It is D.
https://docs.snowflake.com/en/user-guide/override_share_restrictions -> By default, Snowflake does not allow sharing data from a Business Critical to a non-Business Critical account.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
serg_khar
Highly Voted 1 year, 7 months agolaksnarn
Most Recent 4 months, 3 weeks agoMariusdeWith
1 year agoPedroSDG
1 year agoPedroSDG
1 year agohillcat111
1 year, 4 months ago