If a masking policy references an external function, what is the effect on sharing the table or view?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

If a masking policy references an external function, what is the effect on sharing the table or view?

Explanation:
Masking policies that reference an external function depend on behavior outside Snowflake during evaluation. When sharing data across accounts, Snowflake must ensure the recipient can evaluate the policy without relying on resources not present in the share. External functions aren’t guaranteed to exist or be accessible in the consumer’s environment, so the policy cannot be enforced reliably in a shared context. To prevent potential policy evaluation issues or data exposure, Snowflake does not allow sharing of a table or view whose masking policy references an external function. If sharing is required, remove the external-function reference from the masking policy or use a masking approach that does not rely on external functions.

Masking policies that reference an external function depend on behavior outside Snowflake during evaluation. When sharing data across accounts, Snowflake must ensure the recipient can evaluate the policy without relying on resources not present in the share. External functions aren’t guaranteed to exist or be accessible in the consumer’s environment, so the policy cannot be enforced reliably in a shared context. To prevent potential policy evaluation issues or data exposure, Snowflake does not allow sharing of a table or view whose masking policy references an external function. If sharing is required, remove the external-function reference from the masking policy or use a masking approach that does not rely on external functions.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy