2.12.6 Data Masking and De-Identification Functions

The following table shows data masking and de-identification functions supported by HeatWave MySQL.

Table 2.6 Data Masking and De-Identification Functions

Name	Description
gen_range()	Generate random number within range
gen_rnd_email()	Generate random email address
gen_rnd_pan()	Generate random payment card Primary Account Number
gen_rnd_ssn()	Generate random US Social Security number
gen_rnd_us_phone()	Generate random US phone number
mask_inner()	Mask interior part of string
mask_outer()	Mask left and right parts of string
mask_pan()	Mask payment card Primary Account Number part of string
mask_pan_relaxed()	Mask payment card Primary Account Number part of string
mask_ssn()	Mask US Social Security number