The custom_types.ttl
file
If you want a masking solution that is reusable then using a custom data type defined in a .ttl
file is a good solution. Custom data types are stored in a .ttl
file in the dataset that is designated to house the organization's ontology files. You can get a copy of our sample custom_types.ttl
from support
and either use it as-is or extend it with your own custom maskings.
The requirements to use a custom data type defined in a .ttl
file are:
Extracted tables only - The column you want to apply the data type to must be in an extracted table located on data.world. Custom data types do not work on live tables yet.
Data types must match - The data type of the column must match the data type defined in the data.world ontology. For example, if the original column is of type
String
, the custom type chosen to apply to the column must also be of typeString
.Data format must follow expected pattern - The format of the data in the column must match the format expected by the custom type. If the custom type is formatted to render US phone numbers with the format XXX-XXX-XXXX, and one of the cells has XXXXXXXXXX, the custom type for the mask will not be applied.