5.3.6 Data Masking and De-Identification Functions

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

Table 5.5 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