Skip to content

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.