Data Tests
Schema Validation Tests
Data Tests
Schema Validation Tests
The Elementary dbt package includes the following schema validation tests:
Schema changes
Fails on changes in schema: deleted or added columns, or change of data type of a column.
Schema changes from baseline
Fails if the table schema is different in columns names or column types than a configured baseline (can be generated with a macro).
JSON schema
Monitors a JSON type column and fails if there are JSON events that don’t match a configured JSON schema (can be generated with a macro).
Exposure schema
Monitors changes in your models’ columns that break schema for downstream exposures, such as BI dashboards.