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) |