Skip to main content

Privacera Documentation

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)