Skip to content

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.