Skip to content

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