Custom Metrics

Define and monitor custom metrics tailored to your needs so you can create expectations and monitor anything in your data. Simply define SQL query for the metric, and Upriver will handle the rest -profiling the metric and setting up real-time monitoring to track adherence to expectations.

Custom defined user metric calculated based on fields in the data source

Metric Tracking

For each custom metric, Upriver applies all the automated monitors as they would be for any other field. See Field Behavior Monitoring.

Metric Status

• Running - The metric was successfully retried in the last contract update run.

• Failed - The metric was not updated in the last contract update run due to an error.

• Pending - There has been no contract update since the metric was last defined.

Defining a Custom Metric

From the datasource details page, clicking on the tab Custom Metrics. This should open a list of all the custom metrics currently defined for the given data source.

List of defined custom metrics for a data source

In this tab, click on the Add Custom Metric button and a dialog will open.

New metric dialog

In the new dialog, enter the name of the metric and the custom SQL query that will be used to define the metric.

Users can decide to select the Validate query checkbox. This will ensure that the query is valid by checking both the syntax and validating that the fields used in the query exist and are of the relevant type according to the existing data contract for the data sourcee.

Updating an existing metric

To update an existing metric, expand the metric row in the list and select the metric definition tab. Within the sql editor presenting the query definition, click on the edit button. This opens the Edit Custom Metric dialog and allows you to change the metric.

If the metric has been updated, the existing profiles for the metrics will be continue to be update. If you want to reset them, please delete the current metric and create a new one.

Deleting a Custom Metric

From the custom metric list, select the rows you want to select using the select box. Once metrics are selected, a trash icon (🗑️) will appear next to the Add Custom Metric button. Clicking on it will delete the defined metric.