Data delay metrics

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

1. Under Select data asset, choose a datasource, schema, and table.

2. Under Configure metric, some fields may be inheriting values from the table you chose. You'll need to enter values for any that are empty. To use 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.

3. Optionally, to create a WHERE clause select Add + on the right side of the form, beside Where clause. New fields appear under Where clause that you can use to specify the necessary condition. To delete a WHERE clause, use the waste bin icon beside it to the right.

Delete a where-clause by selecting this icon

4. Optionally add any tags, then in the top right corner select Next to proceed to Step 3 (Preview).

Step 3 (Preview)

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.

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.