Question 420
During a Snowflake architecture review, the team finds: An external consumer sees a shared database listed but a read query fails because the receiving account role has no access to imported objects. Which explanation best accounts for the observed behavior?
Explanation
Correct Answer
The described symptoms indicate that importing a share does not automatically grant every consumer role usage and select privileges. The appropriate resolution is: Grant approved imported-database privileges through the consumer's authorized roles. Confirm with: The intended consumer role queries shared objects and unrelated consumer roles remain restricted.
Incorrect Answers
Sharing unprotected base data would reveal more information than the collaboration needs. “Use an appropriate secured view or protected projection in the authorized share” would address that alternative cause, not the condition in this question: importing a share does not automatically grant every consumer role usage and select privileges.
“Create an authorized Secure Data Sharing share of the selected objects for the consumer account” responds to this separate finding: the collaboration requirement is live governed read access rather than recurring file transfer. This question instead needs “Grant approved imported-database privileges through the consumer's authorized roles”, so the alternative does not meet the stated condition.
Secure Data Sharing exposes provider objects for read-only consumer use. “Keep writes in the provider's controlled ingestion process or design a separate approved feedback channel” applies to that separate problem. The observed case is an external consumer sees a shared database listed but a read query fails because the receiving account role has no access to imported objects; choosing this alternative would address the wrong failure mode.