How classifying the dynamic data masking algorithms

Hi pmscorca,

In fact, they are different type of masking rules.

For default function, it will output the default value based on column definition instead actual value.

string types, use XXXX.
numeric types use a zero value.
date and time types, use 1900-01-01 00:00:00.0000000 .
binary types use a single byte of ASCII value 0.

For Email function, it will check hte value if they are in email structure and mask the value after the first charater and constant suffix before '.com'. (e.g. [email protected])

For Random function, it will return a random value between the define number range.

For custom string, it will make after first character and before the last charter based on custom padding string in the middle. (prefix,[padding],suffix)

Dynamic data masking in Synapse Data Warehouse - Microsoft Fabric | Microsoft Learn

Regards,

Xiaoxin Sheng