Last updated: July 22, 2025

List of column level whitespace data quality checks

This is a list of whitespace column data quality checks supported by DQOps and a brief description of what data quality issued they detect.

column-level whitespace checks

Detects text columns that contain blank values, or values that are used as placeholders for missing values: 'n/a', 'None', etc.

empty text found

This check detects empty texts that are not null. Empty texts have a length of zero. The database treats them as values different than nulls, and some databases allow the storage of both null and empty values. This check counts empty texts and raises a data quality issue when the number of empty values exceeds a max_count parameter value.

Data quality check name	Friendly name	Check type	Description
`profile_empty_text_found`	Maximum count of empty text values	profiling	Detects empty texts (not null, zero-length texts). This check counts empty and raises a data quality issue when their count exceeds a max_count parameter value.
`daily_empty_text_found`	Maximum count of empty text values	monitoring	Detects empty texts (not null, zero-length texts). This check counts empty and raises a data quality issue when their count exceeds a max_count parameter value. Stores the most recent captured value for each day when the data quality check was evaluated.
`monthly_empty_text_found`	Maximum count of empty text values	monitoring	Detects empty texts (not null, zero-length texts). This check counts empty and raises a data quality issue when their count exceeds a max_count parameter value. Stores the most recent captured value for each day when the data quality check was evaluated.
`daily_partition_empty_text_found`	Maximum count of empty text values	partitioned	Detects empty texts (not null, zero-length texts). This check counts empty and raises a data quality issue when their count exceeds a max_count parameter value. Stores a separate data quality check result for each daily partition.
`monthly_partition_empty_text_found`	Maximum count of empty text values	partitioned	Detects empty texts (not null, zero-length texts). This check counts empty and raises a data quality issue when their count exceeds a max_count parameter value. Stores a separate data quality check result for each monthly partition.

whitespace text found

This check detects empty texts containing only spaces and other whitespace characters. This check counts whitespace-only texts and raises a data quality issue when their count exceeds a max_count parameter value.

Data quality check name	Friendly name	Check type	Description
`profile_whitespace_text_found`	Maximum count of whitespace values	profiling	Detects texts that contain only spaces and other whitespace characters. It raises a data quality issue when their count exceeds a max_count parameter value.
`daily_whitespace_text_found`	Maximum count of whitespace values	monitoring	Detects texts that contain only spaces and other whitespace characters. It raises a data quality issue when their count exceeds a max_count parameter value. Stores the most recent captured value for each day when the data quality check was evaluated.
`monthly_whitespace_text_found`	Maximum count of whitespace values	monitoring	Detects texts that contain only spaces and other whitespace characters. It raises a data quality issue when their count exceeds a max_count parameter value. Stores the most recent captured value for each day when the data quality check was evaluated.
`daily_partition_whitespace_text_found`	Maximum count of whitespace values	partitioned	Detects texts that contain only spaces and other whitespace characters. It raises a data quality issue when their count exceeds a max_count parameter value. Stores a separate data quality check result for each daily partition.
`monthly_partition_whitespace_text_found`	Maximum count of whitespace values	partitioned	Detects texts that contain only spaces and other whitespace characters. It raises a data quality issue when their count exceeds a max_count parameter value. Stores a separate data quality check result for each monthly partition.

null placeholder text found

This check detects text values that are well-known equivalents (placeholders) of a null value, such as null, None, n/a. This check counts null placeholder values and raises a data quality issue when their count exceeds a max_count parameter value.

Data quality check name	Friendly name	Check type	Description
`profile_null_placeholder_text_found`	Maximum count of null placeholder values (i.e., None, n/a, null)	profiling	Detects texts that are well-known placeholders of null values, such as None, null, n/a. It counts null placeholders and raises a data quality issue when their count exceeds a max_count parameter value.
`daily_null_placeholder_text_found`	Maximum count of null placeholder values (i.e., None, n/a, null)	monitoring	Detects texts that are well-known placeholders of null values, such as None, null, n/a. It counts null placeholders and raises a data quality issue when their count exceeds a max_count parameter value. Stores the most recent captured value for each day when the data quality check was evaluated.
`monthly_null_placeholder_text_found`	Maximum count of null placeholder values (i.e., None, n/a, null)	monitoring	Detects texts that are well-known placeholders of null values, such as None, null, n/a. It counts null placeholders and raises a data quality issue when their count exceeds a max_count parameter value. Stores the most recent captured value for each day when the data quality check was evaluated.
`daily_partition_null_placeholder_text_found`	Maximum count of null placeholder values (i.e., None, n/a, null)	partitioned	Detects texts that are well-known placeholders of null values, such as None, null, n/a. It counts null placeholders and raises a data quality issue when their count exceeds a max_count parameter value. Stores a separate data quality check result for each daily partition.
`monthly_partition_null_placeholder_text_found`	Maximum count of null placeholder values (i.e., None, n/a, null)	partitioned	Detects texts that are well-known placeholders of null values, such as None, null, n/a. It counts null placeholders and raises a data quality issue when their count exceeds a max_count parameter value. Stores a separate data quality check result for each monthly partition.

empty text percent

This check detects empty texts that are not null. Empty texts have a length of zero. This check measures the percentage of empty texts and raises a data quality issue when the rate of empty values exceeds a max_percent parameter value.

Data quality check name	Friendly name	Check type	Description
`profile_empty_text_percent`	Maximum percentage of empty texts values	profiling	Detects empty texts (not null, zero-length texts) and measures their percentage in the column. This check verifies that the rate of empty strings in a column does not exceed the maximum accepted percentage. This check verifies that the rate of empty strings in a column does not exceed the maximum accepted percentage.
`daily_empty_text_percent`	Maximum percentage of empty texts values	monitoring	Detects empty texts (not null, zero-length texts) and measures their percentage in the column. This check verifies that the rate of empty strings in a column does not exceed the maximum accepted percentage. Stores the most recent captured value for each day when the data quality check was evaluated.
`monthly_empty_text_percent`	Maximum percentage of empty texts values	monitoring	Detects empty texts (not null, zero-length texts) and measures their percentage in the column. This check verifies that the rate of empty strings in a column does not exceed the maximum accepted percentage. Stores the most recent captured value for each day when the data quality check was evaluated.
`daily_partition_empty_text_percent`	Maximum percentage of empty texts values	partitioned	Detects empty texts (not null, zero-length texts) and measures their percentage in the column. This check verifies that the rate of empty strings in a column does not exceed the maximum accepted percentage. Stores a separate data quality check result for each daily partition.
`monthly_partition_empty_text_percent`	Maximum percentage of empty texts values	partitioned	Detects empty texts (not null, zero-length texts) and measures their percentage in the column. This check verifies that the rate of empty strings in a column does not exceed the maximum accepted percentage. Stores a separate data quality check result for each monthly partition.

whitespace text percent

This check detects empty texts containing only spaces and other whitespace characters. This check measures the percentage of whitespace-only texts and raises a data quality issue when their rate exceeds a max_percent parameter value.

Data quality check name	Friendly name	Check type	Description
`profile_whitespace_text_percent`	Maximum percentage of whitespace values	profiling	Detects texts that contain only spaces and other whitespace characters and measures their percentage in the column. It raises a data quality issue when their rate exceeds a max_percent parameter value.
`daily_whitespace_text_percent`	Maximum percentage of whitespace values	monitoring	Detects texts that contain only spaces and other whitespace characters and measures their percentage in the column. It raises a data quality issue when their rate exceeds a max_percent parameter value. Stores the most recent captured value for each day when the data quality check was evaluated.
`monthly_whitespace_text_percent`	Maximum percentage of whitespace values	monitoring	Detects texts that contain only spaces and other whitespace characters and measures their percentage in the column. It raises a data quality issue when their rate exceeds a max_percent parameter value. Stores the most recent captured value for each day when the data quality check was evaluated.
`daily_partition_whitespace_text_percent`	Maximum percentage of whitespace values	partitioned	Detects texts that contain only spaces and other whitespace characters and measures their percentage in the column. It raises a data quality issue when their rate exceeds a max_percent parameter value. Stores a separate data quality check result for each daily partition.
`monthly_partition_whitespace_text_percent`	Maximum percentage of whitespace values	partitioned	Detects texts that contain only spaces and other whitespace characters and measures their percentage in the column. It raises a data quality issue when their rate exceeds a max_percent parameter value. Stores a separate data quality check result for each monthly partition.

null placeholder text percent

This check detects text values that are well-known equivalents (placeholders) of a null value, such as null, None, n/a. This check measures the percentage of null placeholder values and raises a data quality issue when their rate exceeds a max_percent parameter value.

Data quality check name	Friendly name	Check type	Description
`profile_null_placeholder_text_percent`	Maximum percentage of null placeholder values (i.e., None, n/a, null)	profiling	Detects texts that are well-known placeholders of null values, such as None, null, n/a, and measures their percentage in the column. It raises a data quality issue when their rate exceeds a max_percent parameter value.
`daily_null_placeholder_text_percent`	Maximum percentage of null placeholder values (i.e., None, n/a, null)	monitoring	Detects texts that are well-known placeholders of null values, such as None, null, n/a, and measures their percentage in the column. It raises a data quality issue when their rate exceeds a max_percent parameter value. Stores the most recent captured value for each day when the data quality check was evaluated.
`monthly_null_placeholder_text_percent`	Maximum percentage of null placeholder values (i.e., None, n/a, null)	monitoring	Detects texts that are well-known placeholders of null values, such as None, null, n/a, and measures their percentage in the column. It raises a data quality issue when their rate exceeds a max_percent parameter value. Stores the most recent captured value for each day when the data quality check was evaluated.
`daily_partition_null_placeholder_text_percent`	Maximum percentage of null placeholder values (i.e., None, n/a, null)	partitioned	Detects texts that are well-known placeholders of null values, such as None, null, n/a, and measures their percentage in the column. It raises a data quality issue when their rate exceeds a max_percent parameter value. Stores a separate data quality check result for each daily partition.
`monthly_partition_null_placeholder_text_percent`	Maximum percentage of null placeholder values (i.e., None, n/a, null)	partitioned	Detects texts that are well-known placeholders of null values, such as None, null, n/a, and measures their percentage in the column. It raises a data quality issue when their rate exceeds a max_percent parameter value. Stores a separate data quality check result for each monthly partition.

text surrounded by whitespace found

This check detects text values that contain additional whitespace characters before or after the text. This check counts text values surrounded by whitespace characters (on any side) and raises a data quality issue when their count exceeds a max_count parameter value. Whitespace-surrounded texts should be trimmed before loading to another table.

Data quality check name	Friendly name	Check type	Description
`profile_text_surrounded_by_whitespace_found`	Maximum count of text surrounded by whitespace characters	profiling	Detects text values that are surrounded by whitespace characters on any side. This check counts whitespace-surrounded texts and raises a data quality issue when their count exceeds the max_count parameter value.
`daily_text_surrounded_by_whitespace_found`	Maximum count of text surrounded by whitespace characters	monitoring	Detects text values that are surrounded by whitespace characters on any side. This check counts whitespace-surrounded texts and raises a data quality issue when their count exceeds the max_count parameter value. Stores the most recent captured value for each day when the data quality check was evaluated.
`monthly_text_surrounded_by_whitespace_found`	Maximum count of text surrounded by whitespace characters	monitoring	Detects text values that are surrounded by whitespace characters on any side. This check counts whitespace-surrounded texts and raises a data quality issue when their count exceeds the max_count parameter value. Stores the most recent captured value for each month when the data quality check was evaluated.
`daily_partition_text_surrounded_by_whitespace_found`	Maximum count of text surrounded by whitespace characters	partitioned	Detects text values that are surrounded by whitespace characters on any side. This check counts whitespace-surrounded texts and raises a data quality issue when their count exceeds the max_count parameter value. Analyzes every daily partition and creates a separate data quality check result with the time period value that identifies the daily partition.
`monthly_partition_text_surrounded_by_whitespace_found`	Maximum count of text surrounded by whitespace characters	partitioned	Detects text values that are surrounded by whitespace characters on any side. This check counts whitespace-surrounded texts and raises a data quality issue when their count exceeds the max_count parameter value. Analyzes every monthly partition and creates a separate data quality check result with the time period value that identifies the monthly partition.

text surrounded by whitespace percent

This check detects text values that contain additional whitespace characters before or after the text. This check measures the percentage of text value surrounded by whitespace characters (on any side) and raises a data quality issue when their rate exceeds a max_percent parameter value.

Data quality check name	Friendly name	Check type	Description
`profile_text_surrounded_by_whitespace_percent`	Maximum percentage of text surrounded by whitespace characters	profiling	This check detects text values that are surrounded by whitespace characters on any side and measures their percentage. This check raises a data quality issue when their percentage exceeds the max_percent parameter value.
`daily_text_surrounded_by_whitespace_percent`	Maximum percentage of text surrounded by whitespace characters	monitoring	This check detects text values that are surrounded by whitespace characters on any side and measures their percentage. This check raises a data quality issue when their percentage exceeds the max_percent parameter value. Stores the most recent captured value for each day when the data quality check was evaluated.
`monthly_text_surrounded_by_whitespace_percent`	Maximum percentage of text surrounded by whitespace characters	monitoring	This check detects text values that are surrounded by whitespace characters on any side and measures their percentage. This check raises a data quality issue when their percentage exceeds the max_percent parameter value. Stores the most recent captured value for each month when the data quality check was evaluated.
`daily_partition_text_surrounded_by_whitespace_percent`	Maximum percentage of text surrounded by whitespace characters	partitioned	This check detects text values that are surrounded by whitespace characters on any side and measures their percentage. This check raises a data quality issue when their percentage exceeds the max_percent parameter value. Analyzes every daily partition and creates a separate data quality check result with the time period value that identifies the daily partition.
`monthly_partition_text_surrounded_by_whitespace_percent`	Maximum percentage of text surrounded by whitespace characters	partitioned	This check detects text values that are surrounded by whitespace characters on any side and measures their percentage. This check raises a data quality issue when their percentage exceeds the max_percent parameter value. Analyzes every monthly partition and creates a separate data quality check result with the time period value that identifies the monthly partition.