Last updated: July 22, 2025
List of column level accuracy data quality checks
This is a list of accuracy column data quality checks supported by DQOps and a brief description of what data quality issued they detect.
column-level accuracy checks
total sum match percent
A column-level check that ensures that the difference between the sum of all values in the tested column and the sum of values in another column in a referenced table is below a maximum accepted percentage of difference. This check runs an SQL query with an INNER JOIN clause to join another (referenced) table that must be defined in the same database.
Data quality check name | Friendly name | Check type | Description | Standard |
---|---|---|---|---|
profile_total_sum_match_percent |
The maximum difference in percent between the total sums of this column and the reference column | profiling | Verifies that percentage of the difference in total sum of a column in a table and total sum of a column of another table does not exceed the set number. | |
daily_total_sum_match_percent |
The maximum difference in percent between the total sums of this column and the reference column | monitoring | Verifies that the percentage of difference in total sum of a column in a table and total sum of a column of another table does not exceed the set number. Stores the most recent captured value for each day when the data quality check was evaluated. | |
monthly_total_sum_match_percent |
The maximum difference in percent between the total sums of this column and the reference column | monitoring | Verifies that the percentage of difference in total sum of a column in a table and total sum of a column of another table does not exceed the set number. Stores the most recent check result for each month when the data quality check was evaluated. |
total min match percent
A column-level check that ensures that the difference between the minimum value in the tested column and the minimum value in another column in a referenced table is below a maximum accepted percentage of difference. This check runs an SQL query with an INNER JOIN clause to join another (referenced) table that must be defined in the same database.
Data quality check name | Friendly name | Check type | Description | Standard |
---|---|---|---|---|
profile_total_min_match_percent |
The maximum difference in percent between the minimum value of this column and the reference column | profiling | Verifies that the percentage of difference in total min of a column in a table and total min of a column of another table does not exceed the set number. | |
daily_total_min_match_percent |
The maximum difference in percent between the minimum value of this column and the reference column | monitoring | Verifies that the percentage of difference in total min of a column in a table and total min of a column of another table does not exceed the set number. Stores the most recent captured value for each day when the data quality check was evaluated. | |
monthly_total_min_match_percent |
The maximum difference in percent between the minimum value of this column and the reference column | monitoring | Verifies that the percentage of difference in total min of a column in a table and total min of a column of another table does not exceed the set number. Stores the most recent check result for each month when the data quality check was evaluated. |
total max match percent
A column-level check that ensures that the difference between the maximum value in the tested column and the maximum value in another column in a referenced table is below a maximum accepted percentage of difference. This check runs an SQL query with an INNER JOIN clause to join another (referenced) table that must be defined in the same database.
Data quality check name | Friendly name | Check type | Description | Standard |
---|---|---|---|---|
profile_total_max_match_percent |
The maximum difference in percent between the maximum value of this column and the reference column | profiling | Verifies that the percentage of difference in total max of a column in a table and total max of a column of another table does not exceed the set number. | |
daily_total_max_match_percent |
The maximum difference in percent between the maximum value of this column and the reference column | monitoring | Verifies that the percentage of difference in total max of a column in a table and total max of a column of another table does not exceed the set number. Stores the most recent captured value for each day when the data quality check was evaluated. | |
monthly_total_max_match_percent |
The maximum difference in percent between the maximum value of this column and the reference column | monitoring | Verifies that the percentage of difference in total max of a column in a table and total max of a column of another table does not exceed the set number. Stores the most recent check result for each month when the data quality check was evaluated. |
total average match percent
A column-level check that ensures that the difference between the average value in the tested column and the average value of another column in the referenced table is below the maximum accepted percentage of difference. This check runs an SQL query with an INNER JOIN clause to join another (referenced) table that must be defined in the same database.
Data quality check name | Friendly name | Check type | Description | Standard |
---|---|---|---|---|
profile_total_average_match_percent |
The maximum difference in percent between the average value of this column and the reference column | profiling | Verifies that the percentage of difference in total average of a column in a table and total average of a column of another table does not exceed the set number. | |
daily_total_average_match_percent |
The maximum difference in percent between the average value of this column and the reference column | monitoring | Verifies that the percentage of difference in total average of a column in a table and total average of a column of another table does not exceed the set number. Stores the most recent captured value for each day when the data quality check was evaluated. | |
monthly_total_average_match_percent |
The maximum difference in percent between the average value of this column and the reference column | monitoring | Verifies that the percentage of difference in total average of a column in a table and total average of a column of another table does not exceed the set number. Stores the most recent check result for each month when the data quality check was evaluated. |
total not null count match percent
A column-level check that ensures that the difference between the count of null values in the tested column and the count of null values in another column in a referenced table is below a maximum accepted percentage of difference. This check runs an SQL query with an INNER JOIN clause to join another (referenced) table that must be defined in the same database.
Data quality check name | Friendly name | Check type | Description | Standard |
---|---|---|---|---|
profile_total_not_null_count_match_percent |
The maximum difference in percent between the count of not null values of this column and the reference column | profiling | Verifies that the percentage of difference in total not null count of a column in a table and total not null count of a column of another table does not exceed the set number. Stores the most recent captured value for each day when the data quality check was evaluated. | |
daily_total_not_null_count_match_percent |
The maximum difference in percent between the count of not null values of this column and the reference column | monitoring | Verifies that the percentage of difference in total not null count of a column in a table and total not null count of a column of another table does not exceed the set number. Stores the most recent captured value for each day when the data quality check was evaluated. | |
monthly_total_not_null_count_match_percent |
The maximum difference in percent between the count of not null values of this column and the reference column | monitoring | Verifies that the percentage of difference in total not null count of a column in a table and total not null count of a column of another table does not exceed the set number. Stores the most recent check result for each month when the data quality check was evaluated. |