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