Company A would like to share data in Snowflake with Company B. Company B is not on the same cloud platform as Company A. What is required to allow data sharing between these two companies?
A.
Create a pipeline to write shared data to a cloud storage location in the target cloud provider.
B.
Ensure that all views are persisted, as views cannot be shared across cloud platforms.
C.
Setup data replication to the region and cloud platform where the consumer resides.
D.
Company A and Company B must agree to use a single cloud platform: Data sharing is only possible if the companies share the same cloud provider.
All options have issues..
The correct answer would be to use listings with auto fulfilment which would take care of replication. Option C says replication on its own which implies direct database replication, and is not allowed between organisations...
Since we are interested in Snowflake native offering, I have chosen option D as the potential solution, but it should have been option if its choice is correctly worded
Answer A. It cannot be answer C, because the companies would need to be in the "within the same organization", according to Snowflake documentation for replication.
I don't think it means a direct replication to B's account. A will create an account in the target region and cloud platform for the replication, then share it with B.
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.
caio_tertuliano
2 months agonareeshk
3 months agocloud_ranger
4 months, 3 weeks agoywan1600
1 month, 2 weeks agohillcat111
1 year, 3 months agoSrideviJ
1 year, 4 months ago