Skip to content

Last updated: July 22, 2025

List of column level conversions data quality checks

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

column-level conversions checks

Validates that the values in a text column can be parsed and converted to other data types.

text parsable to boolean percent

Verifies that values in a text column are convertible to a boolean value. Texts are convertible to a boolean value when they are one of the well-known boolean placeholders: '0', '1', 'true', 'false', 'yes', 'no', 'y', 'n'. This check measures the percentage of valid values and raises a data quality issue when the percentage of valid values is below an accepted rate.

Data quality check name Friendly name Check type Description Standard
profile_text_parsable_to_boolean_percent Minimum percentage of rows containing a text parsable to a boolean value profiling Verifies that the percentage of text values that are parsable to a boolean value does not fall below the minimum accepted percentage, text values identified as boolean placeholders are: 0, 1, true, false, t, f, yes, no, y, n.
daily_text_parsable_to_boolean_percent Minimum percentage of rows containing a text parsable to a boolean value monitoring Verifies that the percentage of text values that are parsable to a boolean value does not fall below the minimum accepted percentage, text values identified as boolean placeholders are: 0, 1, true, false, t, f, yes, no, y, n. Stores the most recent captured value for each day when the data quality check was evaluated.
monthly_text_parsable_to_boolean_percent Minimum percentage of rows containing a text parsable to a boolean value monitoring Verifies that the percentage of text values that are parsable to a boolean value does not fall below the minimum accepted percentage, text values identified as boolean placeholders are: 0, 1, true, false, t, f, yes, no, y, n. Stores the most recent captured value for each month when the data quality check was evaluated.
daily_partition_text_parsable_to_boolean_percent Minimum percentage of rows containing a text parsable to a boolean value partitioned Verifies that the percentage of text values that are parsable to a boolean value does not fall below the minimum accepted percentage, text values identified as boolean placeholders are: 0, 1, true, false, t, f, yes, no, y, n. 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_parsable_to_boolean_percent Minimum percentage of rows containing a text parsable to a boolean value partitioned Verifies that the percentage of text values that are parsable to a boolean value does not fall below the minimum accepted percentage, text values identified as boolean placeholders are: 0, 1, true, false, t, f, yes, no, y, n. Analyzes every monthly partition and creates a separate data quality check result with the time period value that identifies the monthly partition.

text parsable to integer percent

Verifies that values in a text column can be parsed and converted to an integer type. This check measures the percentage of valid values and raises a data quality issue when the percentage of valid values is below an accepted rate.

Data quality check name Friendly name Check type Description Standard
profile_text_parsable_to_integer_percent Minimum percentage of rows containing a text parsable to integer profiling Verifies that the percentage text values that are parsable to an integer value in a column does not fall below the minimum accepted percentage
daily_text_parsable_to_integer_percent Minimum percentage of rows containing a text parsable to integer monitoring Verifies that the percentage text values that are parsable to an integer value in a column does not fall below the minimum accepted percentage. Stores the most recent captured value for each day when the data quality check was evaluated.
monthly_text_parsable_to_integer_percent Minimum percentage of rows containing a text parsable to integer monitoring Verifies that the percentage text values that are parsable to an integer value in a column does not fall below the minimum accepted percentage. Stores the most recent captured value for each month when the data quality check was evaluated.
daily_partition_text_parsable_to_integer_percent Minimum percentage of rows containing a text parsable to integer partitioned Verifies that the percentage text values that are parsable to an integer value in a column does not fall below the minimum accepted percentage. 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_parsable_to_integer_percent Minimum percentage of rows containing a text parsable to integer partitioned Verifies that the percentage text values that are parsable to an integer value in a column does not fall below the minimum accepted percentage. Analyzes every monthly partition and creates a separate data quality check result with the time period value that identifies the monthly partition.

text parsable to float percent

Verifies that values in a text column can be parsed and converted to a float (or numeric) type. This check measures the percentage of valid values and raises a data quality issue when the percentage of valid values is below an accepted rate.

Data quality check name Friendly name Check type Description Standard
profile_text_parsable_to_float_percent Minimum percentage of rows containing a text parsable to float profiling Verifies that the percentage text values that are parsable to a float value in a column does not fall below the minimum accepted percentage
daily_text_parsable_to_float_percent Minimum percentage of rows containing a text parsable to float monitoring Verifies that the percentage text values that are parsable to a float value in a column does not fall below the minimum accepted percentage. Stores the most recent captured value for each day when the data quality check was evaluated.
monthly_text_parsable_to_float_percent Minimum percentage of rows containing a text parsable to float monitoring Verifies that the percentage text values that are parsable to a float value in a column does not fall below the minimum accepted percentage. Stores the most recent captured value for each month when the data quality check was evaluated.
daily_partition_text_parsable_to_float_percent Minimum percentage of rows containing a text parsable to float partitioned Verifies that the percentage text values that are parsable to a float value in a column does not fall below the minimum accepted percentage. 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_parsable_to_float_percent Minimum percentage of rows containing a text parsable to float partitioned Verifies that the percentage text values that are parsable to a float value in a column does not fall below the minimum accepted percentage. Analyzes every monthly partition and creates a separate data quality check result with the time period value that identifies the monthly partition.

text parsable to date percent

Verifies that values in a text column can be parsed and converted to a date type. This check measures the percentage of valid values and raises a data quality issue when the percentage of valid values is below an accepted rate.

Data quality check name Friendly name Check type Description Standard
profile_text_parsable_to_date_percent Minimum percentage of rows containing a text parsable to date profiling Verifies that the percentage text values that are parsable to a date value in a column does not fall below the minimum accepted percentage. DQOps uses a safe_cast when possible, otherwise the text is verified using a regular expression
daily_text_parsable_to_date_percent Minimum percentage of rows containing a text parsable to date monitoring Verifies that the percentage text values that are parsable to a date value in a column does not fall below the minimum accepted percentage. DQOps uses a safe_cast when possible, otherwise the text is verified using a regular expression. Stores the most recent captured value for each day when the data quality check was evaluated.
monthly_text_parsable_to_date_percent Minimum percentage of rows containing a text parsable to date monitoring Verifies that the percentage text values that are parsable to a date value in a column does not fall below the minimum accepted percentage. DQOps uses a safe_cast when possible, otherwise the text is verified using a regular expression. Stores the most recent captured value for each month when the data quality check was evaluated.
daily_partition_text_parsable_to_date_percent Minimum percentage of rows containing a text parsable to date partitioned Verifies that the percentage text values that are parsable to a date value in a column does not fall below the minimum accepted percentage. DQOps uses a safe_cast when possible, otherwise the text is verified using a regular expression. 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_parsable_to_date_percent Minimum percentage of rows containing a text parsable to date partitioned Verifies that the percentage text values that are parsable to a date value in a column does not fall below the minimum accepted percentage. DQOps uses a safe_cast when possible, otherwise the text is verified using a regular expression. Analyzes every monthly partition and creates a separate data quality check result with the time period value that identifies the monthly partition.