Last updated: July 22, 2025
List of table level comparisons data quality checks
This is a list of comparisons table data quality checks supported by DQOps and a brief description of what data quality issued they detect.
table-level comparisons checks
Compares the table (the row count, and the column count) to another table in a different data source.
row count match
Table level comparison check that compares the row count of the current (parent) table with the row count of the reference table.
Data quality check name | Friendly name | Check type | Description | Standard |
---|---|---|---|---|
profile_row_count_match |
Maximum percentage of difference between row count of compared tables | profiling | Verifies that the row count of the tested (parent) table matches the row count of the reference table. Compares each group of data with a GROUP BY clause. | |
daily_row_count_match |
Maximum percentage of difference between row count of compared tables | monitoring | Verifies that the row count of the tested (parent) table matches the row count of the reference table. Compares each group of data with a GROUP BY clause. Stores the most recent captured value for each day when the data quality check was evaluated. | |
monthly_row_count_match |
Maximum percentage of difference between row count of compared tables | monitoring | Verifies that the row count of the tested (parent) table matches the row count of the reference table. Compares each group of data with a GROUP BY clause. Stores the most recent captured value for each month when the data quality check was evaluated. | |
daily_partition_row_count_match |
Maximum percentage of difference between row count of compared tables | partitioned | Verifies that the row count of the tested (parent) table matches the row count of the reference table. Compares each group of data with a GROUP BY clause on the time period (the daily partition) and all other data grouping columns. Stores the most recent captured value for each daily partition that was analyzed. | |
monthly_partition_row_count_match |
Maximum percentage of difference between row count of compared tables | partitioned | Verifies that the row count of the tested (parent) table matches the row count of the reference table, for each monthly partition (grouping rows by the time period, truncated to the month). Compares each group of data with a GROUP BY clause. Stores the most recent captured value for each monthly partition and optionally data groups. |
column count match
Table level comparison check that compares the column count of the current (parent) table with the column count of the reference table.
Data quality check name | Friendly name | Check type | Description | Standard |
---|---|---|---|---|
profile_column_count_match |
Maximum percentage of difference between column count of compared tables | profiling | Verifies that the column count of the tested (parent) table matches the column count of the reference table. Only one comparison result is returned, without data grouping. | |
daily_column_count_match |
Maximum percentage of difference between column count of compared tables | monitoring | Verifies that the column count of the tested (parent) table matches the column count of the reference table. Only one comparison result is returned, without data grouping. Stores the most recent captured value for each day when the data quality check was evaluated. | |
monthly_column_count_match |
Maximum percentage of difference between column count of compared tables | monitoring | Verifies that the column count of the tested (parent) table matches the column count of the reference table. Only one comparison result is returned, without data grouping. Stores the most recent captured value for each month when the data quality check was evaluated. |