How do I test data quality on MotherDuck as part of the pipeline?
Attach column and custom checks to your MotherDuck assets. Bruin runs them against MotherDuck on every run, so bad data blocks the pipeline instead of surfacing in a dashboard.
Command
bruin runDefined in
YAML + SQL
Works with
MotherDuck + Bruin CLI
What you get
In-pipeline checksblocking gatesno separate test tool
How it works in code
columns:
- name: amount
checks: [not_null, positive]Run bruin run and the run against MotherDuck stops the moment a check fails.
Related use cases
Quality gates by warehouse
Run data quality checks on Snowflake
How do I test data quality on Snowflake as part of the pipeline?
Quality gates by warehouseRun data quality checks on BigQuery
How do I test data quality on BigQuery as part of the pipeline?
Quality gates by warehouseRun data quality checks on Postgres
How do I test data quality on Postgres as part of the pipeline?
Catch bad data before it ships
Open source. Built-in and custom checks that run on every pipeline run.