Thursday, November 21, 2019

Data Platform Tips 5 - Dynamic Data Masking

Dynamic Data Masking allows to limit the exposure of sensitive data to the users. Really easy and handy to secure data in your SQL Database, Azure SQL Database or Azure Synapse Analytics (Azure SQL DW).

Different types of masking

  • Default - Completely masks the entire column according to the designated data types.
  • Email - Masks everything instead of first letter of the email address, @ symbol and the constant suffix e.g. .com, .net etc.
  • Random - Use on any numeric type to mask the original value with a random value within a specified range.
  • Custom using Partial function - Masking method that exposes the first and last letters and adds a custom padding string in the middle. prefix,[padding],suffix. Masks everything in between the prefix and suffix.


No comments:

Post a Comment