Grouped-by Monitors

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.

Setting Up Grouped-by monitoring

For initial steps you can refer to below links:

• Set Up Freshness & Volume Monitors

• Set Up Custom SQL Monitors

• Set Up Field Health monitors

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.

Configure: On-demand /Schedule Monitor Grouped By for Custom SQL

• 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.

Configure Grouped-by (Other Tests)

• 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