How do I check foreign keys on Postgres?
Use a custom check that returns orphaned keys on Postgres. If any exist the run fails, so joins downstream stay correct.
Command
bruin runDefined in
YAML + SQL
Works with
Postgres + Bruin CLI
What you get
Referential integrityin-pipelineblocking
How it works in code
custom_checks:
- name: fresh
query: SELECT count(*) FROM t WHERE loaded_at < now() - interval '1 day' -- postgresRun bruin run and the Postgres run stops the moment the rule is violated.
Related use cases
Quality checks by warehouse
Enforce freshness on Snowflake source tables
How do I fail a run when a Snowflake source is stale?
Quality checks by warehouseCatch row-count anomalies on Snowflake
How do I detect a broken load on Snowflake?
Quality checks by warehouseEnforce a data contract on Snowflake
How do I enforce a schema contract on a Snowflake table?
Catch bad data before it ships
Open source. Built-in and custom checks that run on every pipeline run.