QuestionQ26

VerifiedOfficial exam objectives/topics

A secure function returns data received through an inbound share.

What occurs if a Data Engineer attempts to grant USAGE privileges on this function to an outbound share?

Explanation

Snowflake does not allow a database or database object created from an inbound share to be reshared by granting its privileges to a different share; attempting the grant returns an error. Resharing, where enabled, requires a locally owned secure view that references the imported data rather than directly sharing the imported object.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!