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. |