Snowflake DBA

Data Governance & Privacy

Question

Dynamic data masking vs. row access policies: what differs, and when should each be used?

Answer

Dynamic data masking transforms protected column values at query time. Row access policies determine which table or view rows are returned. Use masking for attribute-level exposure; use row access for tenant, region, or entitlement-based row visibility. Enterprise Edition or higher.

This is 15 of 21 free samples for Snowflake DBA.

More Snowflake DBA topic samples