Grouped-by Monitors
This document provides conceptual information for leveraging the Grouped By option in your data quality workflows.
Last updated
This document provides conceptual information for leveraging the Grouped By option in your data quality workflows.
Last updated
By utilizing Group By monitors, data teams have the ability to highlight and define specific segments within a table, like those aggregated by values in a dimension column. Following this segmentation, monitors can be applied. This functionality enables teams to not only track the overall row count of a table but also monitor counts of its individual logical subdivisions.
The configuration process for Grouped-by monitors differs from the setup routine of other monitor types, here's how you begin setting up for Grouped-by monitors.
For initial steps you can refer to below links:
To configure Grouped-by monitors in Field Health follow below steps:
Enable “Grouped By” (if applicable) by toggling the switch.
Select the column for grouping and click Validate.
A success message (“Column is valid to be grouped by”) confirms validation.
Click “Proceed to Monitor Setup” to move to the next step.
Once you select On-demand/Schedule as monitor mode, next step is click on Proceed to monitor setup
button.
Once you click on Proceed to monitor setup
button, you will reach the next page (Configure).
Result Set Group by column: Select from dropdown, This is the column from your query result above that contains the value to group by.
Result Set Mapping: Choose the table and column where your distinct value are pulled from.
Note that if the distinct values in your selected column exceeds more than 100, you will not be able to add that as a group-by column. Please reach out to us if support is required on this.
Fetch Values: Click on Fetch Values button and Select group by fetching values from the grouped-by column selected
Search and select multiple columns: Select from dropdown