Creating a materialized view that uses the non-deterministic function CURRENT_ROLE will result in what?

• A. It will succeed
• B. It will be allowed but restricted
• C. It will fail due to non-deterministic function CURRENT_ROLE
• D. It will create a secure view

Answer: (C)

Materialized views require a deterministic definition to ensure the precomputed results are stable and reproducible. Using a non-deterministic function like CURRENT_ROLE means the result can change depending on the session context or when roles are switched, which would make the materialized view’s contents unreliable across refreshes. Because of this, Snowflake rejects the definition and the creation fails due to the non-deterministic function. If you need to capture role-related information, use a different approach such as a regular view or storing the data in a separate table that isn’t materialized.