Auto metrics

Auto metrics allow you to immediately start monitoring common data quality metrics such as data volume, data delay, null percent, and schema changes. You can enable them with one click when you add a data asset to Explorer (a schema, a table, or a column).

Lightup's auto metrics exist at the schema, table, and column level and are listed below. Note that custom versions of these can also be created - for example, if you want to slice the metric or apply a WHERE clause. These toggleable auto metrics simply give you a very quick way to bootstrap your data quality journey with some common and useful metrics.

Auto metric typeData asset typeWhat it measures
Table ActivitySchemaMeasures tables added or dropped from a schema.
Column ActivityTableMeasures columns added, altered (data type), or dropped from a table.
Data delayTableDelays in the arrival of expected data into data assets (a measure of timeliness).
Data volumeTableDeviations from expected data volumes (a measure of completeness).
DistributionColumnChanges in the distribution of values.
Null percentColumnChanges in the percent of values that are null.
Category ActivityColumnMeasures categories added or dropped from a column.

Since most auto metrics are at the table and column level, you will first have to configure the table. For details, view Configure your table for data quality analysis. The one exception is the schema level Activity metric, which tells you about changes in the tables in your schema. This can be turned on as soon as the schema is made active.

Auto Metrics tab

When you select a table in Explorer, if any auto metrics are enabled they appear on the Auto Metrics tab. You can also use the Auto Metrics tab to enable additional auto metrics.