Answer-first summary for fast verification
Answer: alter share my_share add accounts = xy12345;
The correct command to share data with another account in Snowflake is ALTER SHARE with ADD ACCOUNTS. Option C follows the proper Snowflake syntax for adding consumer accounts to a share. Option A and B use GRANT syntax, which is incorrect for cross-account sharing - GRANT is used for privileges within the same account. Option D has incorrect syntax that doesn't exist in Snowflake. The community discussion confirms this with 100% consensus on C and references the official ALTER SHARE documentation syntax.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A Snowflake user wants to share data using my_share with account xy12345.
Which command should be used?
A
grant usage on share my_share to account xy12345;
B
grant select on share my_share to account xy12345;
C
alter share my_share add accounts = xy12345;
D
alter account xy12345 add share my_share;
No comments yet.