Last updated: July 22, 2025
DQOps data quality schema sensors, SQL examples
All data quality sensors in the schema category supported by DQOps are listed below. Those sensors are measured on a table level.
column count
Table schema data quality sensor that reads the metadata from a monitored data source and counts the number of columns.
Sensor summary
The column count sensor is documented below.
Target | Category | Full sensor name | Source code on GitHub |
---|---|---|---|
table | schema | table/schema/column_count |
sensors/table/schema |
Jinja2 SQL templates
The templates used to generate the SQL query for each data source supported by DQOps is shown below.
column list ordered hash
Table schema data quality sensor detects if the list and order of columns have changed on the table. The sensor calculates a hash of the list of column names. The hash value depends on the names of the columns and the order of the columns.
Sensor summary
The column list ordered hash sensor is documented below.
Target | Category | Full sensor name | Source code on GitHub |
---|---|---|---|
table | schema | table/schema/column_list_ordered_hash |
sensors/table/schema |
Jinja2 SQL templates
The templates used to generate the SQL query for each data source supported by DQOps is shown below.
column list unordered hash
Table schema data quality sensor detects if the list of columns have changed on the table. The sensor calculates a hash of the list of column names. The hash value depends on the names of the columns, but not on the order of columns.
Sensor summary
The column list unordered hash sensor is documented below.
Target | Category | Full sensor name | Source code on GitHub |
---|---|---|---|
table | schema | table/schema/column_list_unordered_hash |
sensors/table/schema |
Jinja2 SQL templates
The templates used to generate the SQL query for each data source supported by DQOps is shown below.
column types hash
Table schema data quality sensor detects if the list of columns has changed or any of the column has a new data type, length, scale, precision or nullability. The sensor calculates a hash of the list of column names and all components of the column's type (the type name, length, scale, precision, nullability). The hash value does not depend on the order of columns.
Sensor summary
The column types hash sensor is documented below.
Target | Category | Full sensor name | Source code on GitHub |
---|---|---|---|
table | schema | table/schema/column_types_hash |
sensors/table/schema |
Jinja2 SQL templates
The templates used to generate the SQL query for each data source supported by DQOps is shown below.
What's next
- Learn how the data quality sensors are defined in DQOps and what is the definition of all Jinja2 macros used in the templates
- Understand how DQOps runs data quality checks, rendering templates to SQL queries