Run mapping
Published 03 November 2024
With the mapping-options.json file now created, the mapping step can be ran to create a masking file.
rganonymize map --options-file mapping-options.json --classification-file classification.json --masking-file masking.json
This takes the mapping-options.json and classification.json files as input, maps the classifications to the relevant masking rules, and outputs a masking.json file:
{
"tables": [
{
"schema": "dbo",
"name": "Customers",
"columns": [
{
"name": "CompanyName",
"dataset": "CompanyNames",
"maxLength": 40
},
{
"name": "ContactName",
"dataset": "FullNames",
"deterministic": true,
"maxLength": 30
}
]
},
{
"schema": "dbo",
"name": "Shippers",
"columns": [
{
"name": "CompanyName",
"dataset": "CompanyNames",
"maxLength": 40
}
]
},
{
"schema": "dbo",
"name": "Suppliers",
"columns": [
{
"name": "CompanyName",
"dataset": "CompanyNames",
"maxLength": 40
},
{
"name": "ContactName",
"dataset": "FamilyNames",
"deterministic": true,
"maxLength": 30
},
{
"name": "HomePage",
"dataset": "Websites",
"preserveNulls": true,
"maxLength": 20
},
{
"name": "ContactTitle",
"dataset": "JobTitles"
}
]
}
],
"datasets": [
{
"name": "JobTitles",
"type": "List",
"values": [ "CEO", "CTO", "Director", "Engineer", "Developer", "Designer", "Analyst", "Consultant" ]
},
{
"name": "CompanyNames",
"type": "List",
"values": [ "Redgate Software", "Microsoft", "Google", "Amazon", "Apple", "Facebook", "Twitter" ]
}
]
}Lines 3-30 show the mapping from the classification file.
Lines 35-39 show the mapping from the classification file.
Lines 40-45 show the corrected classification for the ContactName column of the dbo.Suppliers (A).
Lines 46-51 show the mapping from the classification file.
Lines 52-55 show the custom masking (B).
Lines 60-69 show the custom datasets (C).