Skip to main content

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 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 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 ontology. For example, if the original column is of type String, the custom type chosen to apply to the column must also be of type String.

  • 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.