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