Use Cases · For data engineers
Data quality
Attach column and custom checks to your assets and run them on every pipeline run. Bad data blocks the pipeline instead of surfacing in a dashboard.
Quality checks by warehouse
40 use casesEnforce freshness on Snowflake source tables
How do I fail a run when a Snowflake source is stale?
Catch row-count anomalies on Snowflake
How do I detect a broken load on Snowflake?
Enforce a data contract on Snowflake
How do I enforce a schema contract on a Snowflake table?
Validate referential integrity on Snowflake
How do I check foreign keys on Snowflake?
Enforce freshness on BigQuery source tables
How do I fail a run when a BigQuery source is stale?
Catch row-count anomalies on BigQuery
How do I detect a broken load on BigQuery?
Enforce a data contract on BigQuery
How do I enforce a schema contract on a BigQuery table?
Validate referential integrity on BigQuery
How do I check foreign keys on BigQuery?
Enforce freshness on Postgres source tables
How do I fail a run when a Postgres source is stale?
Catch row-count anomalies on Postgres
How do I detect a broken load on Postgres?
Enforce a data contract on Postgres
How do I enforce a schema contract on a Postgres table?
Validate referential integrity on Postgres
How do I check foreign keys on Postgres?
Enforce freshness on Databricks source tables
How do I fail a run when a Databricks source is stale?
Catch row-count anomalies on Databricks
How do I detect a broken load on Databricks?
Enforce a data contract on Databricks
How do I enforce a schema contract on a Databricks table?
Validate referential integrity on Databricks
How do I check foreign keys on Databricks?
Enforce freshness on Redshift source tables
How do I fail a run when a Redshift source is stale?
Catch row-count anomalies on Redshift
How do I detect a broken load on Redshift?
Enforce a data contract on Redshift
How do I enforce a schema contract on a Redshift table?
Validate referential integrity on Redshift
How do I check foreign keys on Redshift?
Enforce freshness on DuckDB source tables
How do I fail a run when a DuckDB source is stale?
Catch row-count anomalies on DuckDB
How do I detect a broken load on DuckDB?
Enforce a data contract on DuckDB
How do I enforce a schema contract on a DuckDB table?
Validate referential integrity on DuckDB
How do I check foreign keys on DuckDB?
Enforce freshness on MotherDuck source tables
How do I fail a run when a MotherDuck source is stale?
Catch row-count anomalies on MotherDuck
How do I detect a broken load on MotherDuck?
Enforce a data contract on MotherDuck
How do I enforce a schema contract on a MotherDuck table?
Validate referential integrity on MotherDuck
How do I check foreign keys on MotherDuck?
Enforce freshness on ClickHouse source tables
How do I fail a run when a ClickHouse source is stale?
Catch row-count anomalies on ClickHouse
How do I detect a broken load on ClickHouse?
Enforce a data contract on ClickHouse
How do I enforce a schema contract on a ClickHouse table?
Validate referential integrity on ClickHouse
How do I check foreign keys on ClickHouse?
Enforce freshness on MySQL source tables
How do I fail a run when a MySQL source is stale?
Catch row-count anomalies on MySQL
How do I detect a broken load on MySQL?
Enforce a data contract on MySQL
How do I enforce a schema contract on a MySQL table?
Validate referential integrity on MySQL
How do I check foreign keys on MySQL?
Enforce freshness on Athena source tables
How do I fail a run when a Athena source is stale?
Catch row-count anomalies on Athena
How do I detect a broken load on Athena?
Enforce a data contract on Athena
How do I enforce a schema contract on a Athena table?
Validate referential integrity on Athena
How do I check foreign keys on Athena?
Quality gates by warehouse
12 use casesRun data quality checks on Snowflake
How do I test data quality on Snowflake as part of the pipeline?
Run data quality checks on BigQuery
How do I test data quality on BigQuery as part of the pipeline?
Run data quality checks on Postgres
How do I test data quality on Postgres as part of the pipeline?
Run data quality checks on Databricks
How do I test data quality on Databricks as part of the pipeline?
Run data quality checks on Redshift
How do I test data quality on Redshift as part of the pipeline?
Run data quality checks on DuckDB
How do I test data quality on DuckDB as part of the pipeline?
Run data quality checks on MotherDuck
How do I test data quality on MotherDuck as part of the pipeline?
Run data quality checks on ClickHouse
How do I test data quality on ClickHouse as part of the pipeline?
Run data quality checks on MySQL
How do I test data quality on MySQL as part of the pipeline?
Run data quality checks on Athena
How do I test data quality on Athena as part of the pipeline?
Run data quality checks on Synapse
How do I test data quality on Synapse as part of the pipeline?
Run data quality checks on Microsoft Fabric
How do I test data quality on Microsoft Fabric as part of the pipeline?
Freshness by warehouse
12 use casesCheck freshness on Snowflake
How do I check freshness on Snowflake?
Check freshness on BigQuery
How do I check freshness on BigQuery?
Check freshness on Databricks
How do I check freshness on Databricks?
Check freshness on Postgres
How do I check freshness on Postgres?
Check freshness on Redshift
How do I check freshness on Redshift?
Check freshness on ClickHouse
How do I check freshness on ClickHouse?
Check freshness on DuckDB
How do I check freshness on DuckDB?
Check freshness on MotherDuck
How do I check freshness on MotherDuck?
Check freshness on MySQL
How do I check freshness on MySQL?
Check freshness on Athena
How do I check freshness on Athena?
Check freshness on Synapse
How do I check freshness on Synapse?
Check freshness on Microsoft Fabric
How do I check freshness on Microsoft Fabric?
Completeness by warehouse
12 use casesCheck completeness on Snowflake
How do I check completeness on Snowflake?
Check completeness on BigQuery
How do I check completeness on BigQuery?
Check completeness on Databricks
How do I check completeness on Databricks?
Check completeness on Postgres
How do I check completeness on Postgres?
Check completeness on Redshift
How do I check completeness on Redshift?
Check completeness on ClickHouse
How do I check completeness on ClickHouse?
Check completeness on DuckDB
How do I check completeness on DuckDB?
Check completeness on MotherDuck
How do I check completeness on MotherDuck?
Check completeness on MySQL
How do I check completeness on MySQL?
Check completeness on Athena
How do I check completeness on Athena?
Check completeness on Synapse
How do I check completeness on Synapse?
Check completeness on Microsoft Fabric
How do I check completeness on Microsoft Fabric?
Uniqueness by warehouse
12 use casesCheck uniqueness on Snowflake
How do I check uniqueness on Snowflake?
Check uniqueness on BigQuery
How do I check uniqueness on BigQuery?
Check uniqueness on Databricks
How do I check uniqueness on Databricks?
Check uniqueness on Postgres
How do I check uniqueness on Postgres?
Check uniqueness on Redshift
How do I check uniqueness on Redshift?
Check uniqueness on ClickHouse
How do I check uniqueness on ClickHouse?
Check uniqueness on DuckDB
How do I check uniqueness on DuckDB?
Check uniqueness on MotherDuck
How do I check uniqueness on MotherDuck?
Check uniqueness on MySQL
How do I check uniqueness on MySQL?
Check uniqueness on Athena
How do I check uniqueness on Athena?
Check uniqueness on Synapse
How do I check uniqueness on Synapse?
Check uniqueness on Microsoft Fabric
How do I check uniqueness on Microsoft Fabric?
Null rate by warehouse
12 use casesCheck null rate on Snowflake
How do I check null rate on Snowflake?
Check null rate on BigQuery
How do I check null rate on BigQuery?
Check null rate on Databricks
How do I check null rate on Databricks?
Check null rate on Postgres
How do I check null rate on Postgres?
Check null rate on Redshift
How do I check null rate on Redshift?
Check null rate on ClickHouse
How do I check null rate on ClickHouse?
Check null rate on DuckDB
How do I check null rate on DuckDB?
Check null rate on MotherDuck
How do I check null rate on MotherDuck?
Check null rate on MySQL
How do I check null rate on MySQL?
Check null rate on Athena
How do I check null rate on Athena?
Check null rate on Synapse
How do I check null rate on Synapse?
Check null rate on Microsoft Fabric
How do I check null rate on Microsoft Fabric?
Accepted values by warehouse
12 use casesCheck accepted values on Snowflake
How do I check accepted values on Snowflake?
Check accepted values on BigQuery
How do I check accepted values on BigQuery?
Check accepted values on Databricks
How do I check accepted values on Databricks?
Check accepted values on Postgres
How do I check accepted values on Postgres?
Check accepted values on Redshift
How do I check accepted values on Redshift?
Check accepted values on ClickHouse
How do I check accepted values on ClickHouse?
Check accepted values on DuckDB
How do I check accepted values on DuckDB?
Check accepted values on MotherDuck
How do I check accepted values on MotherDuck?
Check accepted values on MySQL
How do I check accepted values on MySQL?
Check accepted values on Athena
How do I check accepted values on Athena?
Check accepted values on Synapse
How do I check accepted values on Synapse?
Check accepted values on Microsoft Fabric
How do I check accepted values on Microsoft Fabric?
Referential integrity by warehouse
12 use casesCheck referential integrity on Snowflake
How do I check referential integrity on Snowflake?
Check referential integrity on BigQuery
How do I check referential integrity on BigQuery?
Check referential integrity on Databricks
How do I check referential integrity on Databricks?
Check referential integrity on Postgres
How do I check referential integrity on Postgres?
Check referential integrity on Redshift
How do I check referential integrity on Redshift?
Check referential integrity on ClickHouse
How do I check referential integrity on ClickHouse?
Check referential integrity on DuckDB
How do I check referential integrity on DuckDB?
Check referential integrity on MotherDuck
How do I check referential integrity on MotherDuck?
Check referential integrity on MySQL
How do I check referential integrity on MySQL?
Check referential integrity on Athena
How do I check referential integrity on Athena?
Check referential integrity on Synapse
How do I check referential integrity on Synapse?
Check referential integrity on Microsoft Fabric
How do I check referential integrity on Microsoft Fabric?
Row count by warehouse
12 use casesCheck row count anomaly on Snowflake
How do I check row count anomaly on Snowflake?
Check row count anomaly on BigQuery
How do I check row count anomaly on BigQuery?
Check row count anomaly on Databricks
How do I check row count anomaly on Databricks?
Check row count anomaly on Postgres
How do I check row count anomaly on Postgres?
Check row count anomaly on Redshift
How do I check row count anomaly on Redshift?
Check row count anomaly on ClickHouse
How do I check row count anomaly on ClickHouse?
Check row count anomaly on DuckDB
How do I check row count anomaly on DuckDB?
Check row count anomaly on MotherDuck
How do I check row count anomaly on MotherDuck?
Check row count anomaly on MySQL
How do I check row count anomaly on MySQL?
Check row count anomaly on Athena
How do I check row count anomaly on Athena?
Check row count anomaly on Synapse
How do I check row count anomaly on Synapse?
Check row count anomaly on Microsoft Fabric
How do I check row count anomaly on Microsoft Fabric?
Schema drift by warehouse
12 use casesCheck schema drift on Snowflake
How do I check schema drift on Snowflake?
Check schema drift on BigQuery
How do I check schema drift on BigQuery?
Check schema drift on Databricks
How do I check schema drift on Databricks?
Check schema drift on Postgres
How do I check schema drift on Postgres?
Check schema drift on Redshift
How do I check schema drift on Redshift?
Check schema drift on ClickHouse
How do I check schema drift on ClickHouse?
Check schema drift on DuckDB
How do I check schema drift on DuckDB?
Check schema drift on MotherDuck
How do I check schema drift on MotherDuck?
Check schema drift on MySQL
How do I check schema drift on MySQL?
Check schema drift on Athena
How do I check schema drift on Athena?
Check schema drift on Synapse
How do I check schema drift on Synapse?
Check schema drift on Microsoft Fabric
How do I check schema drift on Microsoft Fabric?
Data contracts by warehouse
12 use casesCheck data contract on Snowflake
How do I check data contract on Snowflake?
Check data contract on BigQuery
How do I check data contract on BigQuery?
Check data contract on Databricks
How do I check data contract on Databricks?
Check data contract on Postgres
How do I check data contract on Postgres?
Check data contract on Redshift
How do I check data contract on Redshift?
Check data contract on ClickHouse
How do I check data contract on ClickHouse?
Check data contract on DuckDB
How do I check data contract on DuckDB?
Check data contract on MotherDuck
How do I check data contract on MotherDuck?
Check data contract on MySQL
How do I check data contract on MySQL?
Check data contract on Athena
How do I check data contract on Athena?
Check data contract on Synapse
How do I check data contract on Synapse?
Check data contract on Microsoft Fabric
How do I check data contract on Microsoft Fabric?
Custom checks by warehouse
12 use casesCheck custom SQL assertion on Snowflake
How do I check custom SQL assertion on Snowflake?
Check custom SQL assertion on BigQuery
How do I check custom SQL assertion on BigQuery?
Check custom SQL assertion on Databricks
How do I check custom SQL assertion on Databricks?
Check custom SQL assertion on Postgres
How do I check custom SQL assertion on Postgres?
Check custom SQL assertion on Redshift
How do I check custom SQL assertion on Redshift?
Check custom SQL assertion on ClickHouse
How do I check custom SQL assertion on ClickHouse?
Check custom SQL assertion on DuckDB
How do I check custom SQL assertion on DuckDB?
Check custom SQL assertion on MotherDuck
How do I check custom SQL assertion on MotherDuck?
Check custom SQL assertion on MySQL
How do I check custom SQL assertion on MySQL?
Check custom SQL assertion on Athena
How do I check custom SQL assertion on Athena?
Check custom SQL assertion on Synapse
How do I check custom SQL assertion on Synapse?
Check custom SQL assertion on Microsoft Fabric
How do I check custom SQL assertion on Microsoft Fabric?
Custom checks and gates
8 use casesWrite a custom SQL quality check
How do I write a custom check with my own SQL?
Block a pipeline when data quality fails
How do I stop bad data from reaching production tables?
Warn without failing on a soft check
Can I get a warning without failing the whole run?
Enforce a data contract between teams
How do I enforce a schema contract on data another team produces?
Test data quality in CI before merge
Can quality checks run in CI on a pull request?
Check freshness of a source table
How do I make sure a source table is fresh before building on it?
Catch row-count anomalies
How do I detect when a table loads far fewer rows than usual?
Validate referential integrity between tables
How do I check that every foreign key has a matching row?
Built-in column checks
4 use casesAdd a not_null check to a column
Which rows have a missing value in a required column?
Add a unique check to a column
Are there duplicate keys in this table?
Add a accepted_values check to a column
Does this column only contain the values it should?
Add a positive check to a column
Are there negative or zero values where only positive are valid?
Catch bad data before it ships
Open source. Built-in and custom checks that run on every pipeline run.