Skip to content

Last updated: July 22, 2025

List of table level volume data quality checks

This is a list of volume table data quality checks supported by DQOps and a brief description of what data quality issued they detect.

table-level volume checks

Evaluates the overall quality of the table by verifying the number of rows.

row count

This check detects empty or too-small tables. It captures the row count of a tested table. This check raises a data quality issue when the row count is below a minimum accepted value. The default value of the rule parameter min_count is 1 (row), which detects empty tables. When the data grouping is configured, this check will count rows using a GROUP BY clause and verify that each data grouping has an expected minimum number of rows.

Data quality check name Friendly name Check type Description Standard
profile_row_count Minimum row count (empty or too small table) profiling Verifies that the tested table has at least a minimum accepted number of rows. The default configuration of the warning, error and fatal severity rules verifies a minimum row count of one row, which ensures that the table is not empty.
daily_row_count Minimum row count (empty or too small table) monitoring Verifies that the tested table has at least a minimum accepted number of rows. The default configuration of the warning, error and fatal severity rules verifies a minimum row count of one row, which ensures that the table is not empty. Stores the most recent captured row count value for each day when the row count was evaluated.
monthly_row_count Minimum row count (empty or too small table) monitoring Verifies that the tested table has at least a minimum accepted number of rows. The default configuration of the warning, error and fatal severity rules verifies a minimum row count of one row, which ensures that the table is not empty. Stores the most recent captured row count value for each month when the row count was evaluated.
daily_partition_row_count Minimum row count (empty or too small table) partitioned Verifies that each daily partition in the tested table has at least a minimum accepted number of rows. The default configuration of the warning, error and fatal severity rules verifies a minimum row count of one row, which ensures that the partition is not empty.
monthly_partition_row_count Minimum row count (empty or too small table) partitioned Verifies that each monthly partition in the tested table has at least a minimum accepted number of rows. The default configuration of the warning, error and fatal severity rules verifies a minimum row count of one row, which ensures that the partition is not empty.

row count anomaly

This check detects anomalies in the day-to-day changes to the table volume (the row count). It captures the row count for each day and compares the row count change (increase or decrease) since the previous day. This check raises a data quality issue when the change is in the top anomaly_percent percentage of the biggest day-to-day changes.

Data quality check name Friendly name Check type Description Standard
profile_row_count_anomaly Abnormal change in row count since the last known value profiling Detects when the row count has changed too much since the previous day. It uses time series anomaly detection to find the biggest volume changes during the last 90 days.
daily_row_count_anomaly Abnormal change in row count since the last known value monitoring Detects when the row count has changed too much since the previous day. It uses time series anomaly detection to find the biggest volume changes during the last 90 days.
daily_partition_row_count_anomaly Abnormal change in row count since the last known value partitioned Detects outstanding partitions whose volume (the row count) differs too much from the average daily partition size. It uses time series anomaly detection to find the outliers in the partition volume during the last 90 days.

row count change

This check compares the current table volume (the row count) to the last known row count. It raises a data quality issue when the change in row count (increase or decrease) exceeds a maximum accepted percentage of change.

Data quality check name Friendly name Check type Description Standard
profile_row_count_change Maximum relative change in the row count since the last known value profiling Detects when the volume's (row count) change since the last known row count exceeds the maximum accepted change percentage.
daily_row_count_change Maximum relative change in the row count since the last known value monitoring Detects when the volume's (row count) change since the last known row count exceeds the maximum accepted change percentage.
monthly_row_count_change Maximum relative change in the row count since the last known value monitoring Detects when the volume (row count) changes since the last known row count from a previous month exceeds the maximum accepted change percentage.
daily_partition_row_count_change Maximum relative change in the row count since the last known value partitioned Detects when the partition's volume (row count) change between the current daily partition and the previous partition exceeds the maximum accepted change percentage.
monthly_partition_row_count_change Maximum relative change in the row count since the last known value partitioned Detects when the partition's volume (row count) change between the current monthly partition and the previous partition exceeds the maximum accepted change percentage.

row count change 1 day

This check compares the current table volume (the row count) to the row count from the previous day. It raises a data quality issue when the change in row count (increase or decrease) since yesterday exceeds a maximum accepted percentage of change.

Data quality check name Friendly name Check type Description Standard
profile_row_count_change_1_day Maximum relative change in the row count vs 1 day ago profiling Detects when the volume's change (increase or decrease of the row count) since the previous day exceeds the maximum accepted change percentage.
daily_row_count_change_1_day Maximum relative change in the row count vs 1 day ago monitoring Detects when the volume's change (increase or decrease of the row count) since the previous day exceeds the maximum accepted change percentage.
daily_partition_row_count_change_1_day Maximum relative change in the row count vs 1 day ago partitioned Detects when the partition volume change (increase or decrease of the row count) since yesterday's daily partition exceeds the maximum accepted change percentage.

row count change 7 days

This check compares the current table volume (the row count) to the row count seven days ago. This check compares the table volume to a value a week ago to overcome weekly seasonability and to compare Mondays to Mondays, Tuesdays to Tuesdays, etc. It raises a data quality issue when the change in row count (increase or decrease) since a week ago exceeds a maximum accepted percentage of change.

Data quality check name Friendly name Check type Description Standard
profile_row_count_change_7_days Maximum relative change in the row count vs 7 days ago profiling This check verifies that the percentage of change in the table's volume (row count) since seven days ago is below the maximum accepted percentage. Verifying a volume change since a value a week ago overcomes the effect of weekly seasonability.
daily_row_count_change_7_days Maximum relative change in the row count vs 7 days ago monitoring This check verifies that the percentage of change in the table's volume (row count) since seven days ago is below the maximum accepted percentage. Verifying a volume change since a value a week ago overcomes the effect of weekly seasonability.
daily_partition_row_count_change_7_days Maximum relative change in the row count vs 7 days ago partitioned This check verifies that the percentage of change in the partition's volume (row count) since seven days ago is below the maximum accepted percentage. Verifying a volume change since a value a week ago overcomes the effect of weekly seasonability.

row count change 30 days

This check compares the current table volume (the row count) to the row count 30 days ago. This check compares the table volume to a month ago value to overcome monthly seasonability. It raises a data quality issue when the change in row count (increase or decrease) since a value 30 days ago exceeds a maximum accepted percentage of change.

Data quality check name Friendly name Check type Description Standard
profile_row_count_change_30_days Maximum relative change in the row count vs 30 days ago profiling This check verifies that the percentage of change in the table's volume (row count) since thirty days ago is below the maximum accepted percentage. Comparing the current row count to a value 30 days ago overcomes the effect of monthly seasonability.
daily_row_count_change_30_days Maximum relative change in the row count vs 30 days ago monitoring This check verifies that the percentage of change in the table's volume (row count) since thirty days ago is below the maximum accepted percentage. Comparing the current row count to a value 30 days ago overcomes the effect of monthly seasonability.
daily_partition_row_count_change_30_days Maximum relative change in the row count vs 30 days ago partitioned This check verifies that the percentage of change in the partition's volume (row count) since thirty days ago is below the maximum accepted percentage. Comparing the current row count to a value 30 days ago overcomes the effect of monthly seasonability.