Conformity metrics

Conformity metrics let you specify one or more conditions and check the degree to which a data asset conforms to them. To create one, begin at Create a metric, and choose Conformity at Step 1 (Metric Info).

Step 2 (Configure Metric)

After you finish Step 1 (Metric Info), Step 2 (Configure Metric) appears in the main form:

1500
  1. Under Custom Metric Info, make sure the right data asset is selected using the fields from left to right.

πŸ“˜

Table-level conformity check

You can select multiple columns when you specify the data asset for a conformity metric. If you do, the metric will be placed at the table level in the Explorer tree, and the only condition you can add is Is unique (which checks that each combination of the selected columns is unique across rows in the aggregation interval).

  1. To the right of Conditions select Add + to build the condition that checks values for conformity.
    • Unless you choose the Is unique condition, you can add more than one condition.
    • If you add more than one condition, the second and any subsequent conditions must all be true to conform.
    • To delete a condition, use the waste bin icon beside it to the right.
838
  1. Optionally, to create a WHERE clause select Add +. New fields appear under Where clause that you can use to specify the necessary conditions. To delete a WHERE clause, use the waste bin icon beside it to the right. If you add more than one condition, the second and any subsequent conditions added to a WHERE clause use the AND operator (all listed conditions must be met).
  2. Under Configure metric, some fields may be inheriting values from the source table. You'll need to enter values for any that are empty. To use all your own values for these fields, select Override Settings to unlock the fields for editing. Note that if the table you chose has partitions, Lightup detects them and displays relevant settings for them just below the heritable settings. If you decide instead that the metric should use the table's settings, select Inherit Settings to use the current table settings.

πŸ“˜

For help deciding what values to use, see the list under Manage Table Settings.

  1. If the datasource supports it, you can optionally add slices (the option won't appear if it's not supported). Slices can help your metric's query perform better.
  2. If needed, set up seasonality.
  3. If desired, add a failing records query.
  4. Optionally, add any tags you want, then at the top right corner select Next to proceed to Step 3 (Preview).

Step 3 (Preview)

1252

πŸ“˜

Editing a metric

When you edit an existing metric:

  • You'll see an option to view the metric's recent query history as well as a preview.
  • The Create command changes to Save when you edit an existing metric
  1. Select View sample data to see a sample set of rows from the data asset. Lightup returns 100 rows of data from the source table, including metadata. Select Stop Viewing when you're done.
  2. Optionally, adjust the date range for the preview. If you adjust the range, you must pick a start date and an end date.
  3. Select Preview to see a chart of the metric for the date range from the preceding step.

πŸ“˜

Cancel a preview

Some datasources let you cancel a preview, for example because you noticed that date range was wrong. If cancelling is supported, you'll see a Cancel button.

  1. After you're satisfied with the preview, select Create at the top right corner. The Explorer tab opens and displays your new metric in the Explorer tree.