Alter Masking Policy
Apply a Snowflake dynamic data masking policy to a column in a materialized view, table, or view; or alter a column to use a different masking policy.
Read CREATE MASKING POLICY to learn more about the command.
Read Using Column-level Security on Tables and Views for more granular information.
Each row in the Columns property represents one ALTER TABLE query. This is illustrated in the SQL tab.
Properties
Name = string
A human-readable name for the component.
Database = drop-down
The Snowflake database. The special value, [Environment Default], will use the database defined in the environment. Read Databases, Tables and Views - Overview to learn more.
Schema = drop-down
The Snowflake schema. The special value, [Environment Default], will use the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.
Object Type = drop-down
The object type. Choose one of Materialized View, Table, or View.
Object Type = drop-down
Select the specific object you wish to alter a masking policy for.
Columns = column editor
- Column: Select a column to alter a masking policy for.
- Masking Policy: Add a dynamic data masking policy to the column from the drop-down list. Data in a masked column will display as
***MASKED***. A column can only have one masking policy at a time.
| Snowflake | Delta Lake on Databricks | Amazon Redshift | Google BigQuery | Azure Synapse Analytics |
|---|---|---|---|---|
| ✅ | ❌ | ❌ | ❌ | ❌ |