Enable Autometrics

Pre-built DQIs help you get quality management started right away

๐Ÿ“˜

The procedures on this page assume your data assets are already Active. If they aren't, you can activate data assets and enable their autometrics in the same session: follow the steps on Prepare data assets.

Once a data asset is Active, you can enable its autometrics by opening the Manage metrics modal on its parent data asset (in the datasource-schema-table-column hierarchy). Autometrics work right away to help you assess and start managing data quality as soon as possible.

  • To enable autometrics for a schema, you open the Manage metrics modal on the schema's datasource.
  • To enable them for a table, you open the modal on the table's schema.
  • To enable them for a column, you open the modal on the column's table.
988

๐Ÿ“˜

Run a manual scan

You can initiate a datasource scan manuallyโ€” just select Run Manual Scan on the Manage Metrics modal for the datasource. You can cancel a manual scan in the same place.

You can keep the Manage metrics modal open while you enable autometrics, and use it to navigate up or down the data asset's hierarchy. For example, when you use Manage metrics on a schema, all of the schema's tables are listed in the modal. Each table name listed in the modal is a link to open that table in the Manage metrics modal.

Types of autometrics

Autometric typeSupported data assetsWhat it measures
ActivityAllStructural changes to data assets (a measure of accuracy). Table Activity measures tables added or dropped from a schema, Column Activity measures columns added, altered (data type), or dropped from a table, and Category Activity measures categories added or dropped from a column.
Data delayTablesDelays in the arrival of expected data into data assets (a measure of timeliness).
Data volumeTablesDeviations from expected data volumes (a measure of completeness).
DistributionColumnsChanges in the distribution of values.
Null percentColumnsChanges in the percent of values that are null.

Enable autometrics for a datasource

The following procedure steps through the process of enabling autometrics for each kind of data asset: starting with the schema, on to the table, then finishing with the columns.

  1. In the Explorer tree, select a datasource.
  2. On the Actions menu, select Manage Metrics.
1393
  1. In the Manage metrics modal, enable the autometrics you want.
    • Move an autometric's toggle to the right to enable it.
    • Use the checkbox at the top left of the modal to bulk-select schema so you can enable the same autometrics for all of them at one time.
    • When you're finished enabling schema autometrics, select a schema name in the list to open that schema in the Manage metrics modal, which then lists the schema's tables. For example, you might see something like this:
877
  1. The schema's tables are listed in the modal, along with the tables' autometrics. Enable the autometrics you want by moving the toggles to the right.
  2. Select a table's link to open it in the Manage Metrics modal, which lists the table's columns along with available autometrics. Use the modal like you did in prior steps to enable any autometrics.
1182

After you close the Manage metrics modal, the enabled autometrics will appear in Explorer when you select the data asset.

๐Ÿ“˜

  • You'll want to evaluate the autometrics charts to find some date ranges that only have typical, acceptable metric values that you can use to set up a monitor.
  • Autometrics are a great starting point for creating your own metrics.