Skip to main content
Schema tests in Elementary are designed to help you monitor and maintain the integrity of your data structures. These tests are crucial for detecting unexpected changes in your database schema that could potentially break your data pipelines or lead to data quality issues. Elementary offers two types of schema tests:

Schema Changes

Monitors real-time changes in your database schema, alerting you to critical modifications such as deleted tables, added or removed columns, and changes in column data types.

Schema Changes From Baseline

Compares your current schema against a predefined baseline, allowing you to track deviations from an expected schema configuration over time.

​
Why Use Schema Tests?

  1. Catch Breaking Changes: Identify schema modifications that could break downstream processes.
  2. Maintain Data Consistency: Ensure that your data structures remain consistent with your expectations and documentation.
  3. Streamline Development: Easily track schema changes across different environments or over time.

Related topics

Project StrucutureSchema Changes From BaselineRun and Test all your dbt™ ModelsElementary Data.dinorules