Semantic Types
You may define semantic types and apply them to columns of different tables. Columns with the same semantic type will be masked with the same masking algorithm.
-
Go to Settings > Security & Policy > Data Masking.
-
Click Semantic Types.
-
Click Add, and fill in the name and description. Choose a masking algorithm for full and partial conditions respectively, or you may leave it as
default
which means it will use the system default masking algorithm. Click the checkmark to save. -
Go to a table detail page. Click pencil icon and choose value for Semantic Types and Masking Level.
-
Go to SQL Editor, run a query and you will see the masked data.
-
Go back to table detail page, click pencil to edit the column Masking Level and change the masking level to
Partial
. -
Go to SQL Editor, run a query and you will see the partially masked data.