Edit a data quality rule

You can create a new data quality rule.

Prerequisites

Steps

  1. On the main toolbar, click Products icon, and then click Cogwheel icon Settings.
    The Collibra settings page opens.
  2. Click Operating Model.
    The operating model settings appear on the Asset types tab page.
  3. In the tab pane, click Data quality rules.
  4. Click in the row of your data quality rule.
  5. Enter the required information.

    Field

    Description

    Name

    The name of the data quality rule.

    Description

    The description of the data quality rule.

    Path

    The chain of relations to follow from the asset to which the data quality rule is assigned, to the asset containing the actual values.

    Categorization

    The relation type that determines to which subscore the metric belongs.

    The values of an asset at the end of the aggregation path are only taken into account for these subscores if the asset has the relation that you enter here.

    Metrics

    The metrics of a data quality rule define the values that are displayed in the data quality dashboard and which operation should be used when aggregating the value. These values are attributes that are available on the last asset of the aggregation path.

    This section contains a couple of metrics that are fixed for each metrics group:

    • 'Rows Failed', operation 'Total': aggregated sum of failing rows
    • 'Rows Passed', operation 'Total' aggregated sum of passing rows
    • 'Passing Fraction', operation 'Average': aggregated average of the passing fraction (quality score)
    • 'Result', operation 'Logical AND': aggregated logical and of the result: failing or passing

    You can add extra metrics and their corresponding operation by clicking Add Metric.

  6. Click Save.