Edit a data quality rule
You can create a new data quality rule.
Prerequisites
- You have a global role that has the System administration global permission.
Steps
-
On the main toolbar, click
, and then click
Settings.
The Collibra settings page opens. - Click Operating Model.
The operating model settings are shown. - In the tab pane, click Data quality rules.
- Click in the row of your data quality rule.
- 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.
- Click Save.