Anonymization known limitations
Published 09 November 2023
Uniqueness and determinism
- Columns cannot be masked both deterministically and uniquely.
- A pattern based dataset cannot be used to mask a column uniquely.
- The same value may be masked differently across columns if the columns have different lengths, even if the same dataset is used and both columns are masked deterministically.
PostgreSQL
- Inherited tables are not supported.
Other
- Masking may fail on columns that have a check constraint on them.
- Masking can only be done on string, date and exact numeric data types.
- Masking cannot be done within XML or JSON.
- Datasets involving dates cannot be customised.
- If masking fails while partially complete, any changes made to the database cannot be undone. The database should be considered unusable and masking should not be repeated on it.