If a masking policy is set on an underlying table or view column and a materialized view is created from that table or view, the materialized view only contains columns that are not protected by a masking policy.

• A. True
• B. False
• C. Only non masked columns are included
• D. Masking policies are ignored in materialized views

Answer: (A)

Masking policies are applied at read time, while a materialized view stores a precomputed snapshot of a query. Snowflake does not materialize columns that have masking policies, so a materialized view can include only columns that are not protected by a masking policy. This design avoids storing data that would later be subject to dynamic redaction rules, ensuring the materialized view remains deterministic for all users. If a column has a masking policy, it won’t appear in the materialized view at all, and you would need to query the base table or use non-masked columns instead.