Databricks SQL Masking Functions

Masking Function Scope in Databricks SQL
Default Value: Default values given as masked properties
Data type: All
Null Value: Null
Data type: All
Unmasked Value: Actual value
Data type: All
Hash DBX Value: Hashed value
Data type: text/varchar
MASK_MD5 Value: Hashed value
Data type: text/string
Regex Value: Replace value
Data type: text/string
Literal Mask Value: Replace value
Data type: text/string
Partial last 4 characters Value: Replace value
Data type: text/string
Partial first 4 characters Value: Replace value
Data type: text/string
Custom Value: The UDF given as the input.
Data type: All. For example, repeat('xy', 5)

Last update: July 23, 2021