Data Policy Template

A Data Policy Template is a reusable collection of rule definitions that can be applied to multiple Data Quality Policies. Instead of defining rules every time you create a policy, you can create a single template containing multiple rules. When you add this template to a policy, all the rules it contains are automatically evaluated.

Benefits:

  • Saves time by reusing common rule definitions
  • Ensures consistency across multiple policies
  • Simplifies policy creation for new datasets

Adding a Data Policy Template

Follow these steps to create a new Data Policy Template:

  1. Navigate to: Data Reliability > Manage Policies > Data Policy Templates tab.
  2. Click Add Data Policy Template to open the configuration page.
  3. Enter the following details:
    • Name: Provide a descriptive name for the template (e.g., Customer Table Quality Rules).
    • Description: Explain why this template is being created.
    • Select Rules: Choose the rules to include in the template.

Measurement Types and Rule Definitions

Measurement TypeDescriptionExample
Null ValuesVerifies whether selected columns contain null valuesCustomer email should not be null
Schema MatchChecks if column data types match the expected typeCustomer ID must be Integer
Pattern MatchEnsures column values follow a regular expressionEmails must match ^[\w.%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}$
EnumerationsValidates values against a predefined listStatus must be Active, Inactive, or Pending
Tags MatchEnsures values are present in a specified tagProduct category must match a defined tag
Range MatchValidates values fall within a lower and upper boundOrder total between 0 and 10,000
Uniqueness CheckEnsures values in a column are uniqueCustomer ID column must be distinct
Duplicate Row CheckDetects duplicate rows in a datasetEnsure no repeated transaction records
Row CheckValidates total number of rows falls within a rangeTable must have 10,000–12,000 rows
LookupCompares values with a reference table or column; optional SQL filterCheck IDs exist in a reference table where is_active = 'Y'
  1. (Optional) Add Labels by clicking Add Labels and providing key-value pairs for easier categorization.
  2. Click Save to create the template.

Understanding the Data Policy Templates Table

The Data Policy Templates table provides an overview of all templates you have created. You can search for a template by its name.

Column NameDescription
NameName of the data policy template
DescriptionDescription provided when the template was created
Data DimensionsLists data dimensions defined in the template (e.g., Consistency, Uniqueness)
LabelsDisplays any labels associated with the template
Created AtDate and time the template was created
Updated AtMost recent date and time the template was updated
Vertical Ellipsis IconClick to edit or delete the template

Editing a Data Policy Template

  1. Go to the Data Policy Templates tab in Manage Policies.
  2. Click the name of the template you want to edit.
  3. Update the rules, description, or labels as needed.
  4. Click Save to apply the changes.

Example:

  • You have a template Customer Table Rules with 5 rules.
  • You add a new Pattern Match rule to check email formats.
  • After saving, all policies using this template will now automatically include the new rule.
Type to search, ESC to discard
Type to search, ESC to discard
Type to search, ESC to discard