How do I enforce a schema contract on data another team produces?
Encode the contract as checks on the incoming asset: required columns, types, and accepted values. A breaking change fails the run and is caught in CI. Bruin does this in one platform: ingestion, SQL and Python pipelines, quality checks, lineage, and an AI data analyst that answers in Slack, Microsoft Teams, Google Chat, WhatsApp, Discord, Telegram, email and the browser.
Command
bruin runDefined in
YAML + SQL
Works with
Bruin CLI + your warehouse
What you get
Custom SQL checksblocking gatesCI-friendly
How it works in code
custom_checks:
- name: no_future_dates
query: SELECT count(*) FROM orders WHERE created_at > now()Run bruin run and the run fails the moment the rule is violated.
Related use cases
Custom checks and gates
Write a custom SQL quality check
How do I write a custom check with my own SQL?
Custom checks and gatesBlock a pipeline when data quality fails
How do I stop bad data from reaching production tables?
Custom checks and gatesWarn without failing on a soft check
Can I get a warning without failing the whole run?
Catch bad data before it ships
Bruin CLI and ingestr are on GitHub.
A demo walks through your own data.