Individual overrides
Published 15 December 2023
Where to add an override
If you want to correct a column or table individually, then you can include configuration in the "tables" section of the options file.
Add or override a column classification
To add or override a column classification, add the column to your options file, including a "type" on the column.
Example to override a default column classification
{
"tables": [
{
"schema": "Person",
"name": "Person",
"columns": [
{
"name": "Name",
"type": "GivenNames"
}
]
}
]
}Exclude a table or column
To exclude a table or column from being processed, add "exclude": true to the corresponding JSON node. Make sure to use true without quotes, as it's a boolean value.
NB The table or column will still be present in the classification file, but if that file is used in Anonymize Map, then it will be set to be ignored by Anonymize Mask.
Example to exclude an entire table
{
"tables": [
{
"schema": "Person",
"name": "PersonPhone",
"exclude": true
}
]
}Example to exclude a single column
{
"tables": [
{
"schema": "Person",
"name": "PersonPhone",
"columns": [
{
"name": "PhoneNumber",
"exclude": true
}
]
}
]
}