Column-level security with masking policies in Snowflake - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is column-level security in Snowflake?

Column-level security restricts access to specific columns in a table, allowing control over who can see sensitive data in those columns.

beginner

What is a masking policy in Snowflake?

A masking policy defines rules to hide or obfuscate sensitive data in columns based on the user's role or context.

intermediate

How does a masking policy work in Snowflake?

When a user queries a column with a masking policy, Snowflake applies the policy's logic to show either the real data or masked data depending on the user's permissions.

intermediate

Can masking policies be applied to multiple columns in Snowflake?

Yes, you can create multiple masking policies and apply them to different columns as needed to protect sensitive information.

advanced

What is the benefit of using masking policies over just restricting access to columns?

Masking policies allow users to query data without errors but see masked values if they lack permission, improving usability while protecting sensitive data.

What does a masking policy in Snowflake do?

A Encrypts the entire database

B Deletes sensitive columns from tables

C Hides or masks data in columns based on user roles

D Creates backups of sensitive data

Masking policies control how data is shown to users by masking sensitive column data based on roles.

Which Snowflake object do you create to implement column-level masking?

A Stage

B Masking policy

C Warehouse

D Role

Masking policies are the objects that define how to mask column data.

If a user lacks permission, what will they see when querying a masked column?

A Masked or obfuscated data

B An error message

C The full original data

D No rows returned

Users without permission see masked data, not errors or full data.

Can a single masking policy be reused for multiple columns?

A Only for numeric columns

B No, each column needs a unique policy

C Only for columns in different tables

D Yes, if the masking logic applies to those columns

Masking policies can be reused if the same masking logic fits multiple columns.

What is a key advantage of masking policies compared to simply revoking column access?

A Users can still query data without errors but see masked values

B It permanently deletes sensitive data

C It speeds up queries

D It encrypts data at rest

Masking policies allow queries to run smoothly while protecting sensitive data by masking it.

Explain how column-level security with masking policies works in Snowflake.

Think about how data visibility changes depending on who queries it.

Describe the benefits of using masking policies for protecting sensitive data in Snowflake.

Consider why masking is better than just hiding columns.