When manipulating sensitive data, such as names, addresses, credit card or social security numbers, you might want to mask this data.
To protect the original data while having a functional substitute, you can use the Mask data (obfuscation) function.
- Select the column on which you want to apply the data masking.
- In the Functions panel, type Mask data (obfuscation) and click the result to open the options for the associated function.
- In the Masking function drop-down list, select your masking routine, semantic masking for example.
From the Masking mode
drop-down list, select Repeatable.
Selecting Repeatable instead of the default Random mode allows you to select a Seed. This seed is what will define the output of the masking function, ensuring that identical source values will always be output as the same masked values.
- Leave the default Seed value.
- Click Submit.
The data in the column has been replaced by random but usable substitutes. Depending on the semantic type of the column on which you use the Mask data (obfuscation) function, the effect will vary. For more information, see Data Masking effects