Elementary home page
Ask me anything...
⌘K
Ask AI
Join the Community
Join the Community
Search...
Navigation
Data Tests
Schema Validation Tests
Home
Elementary Cloud
dbt Package and Tests
Elementary OSS
Book a Demo
Join Slack
Getting Started
Introduction
Quickstart
Platform features
Integrations
Security and privacy
Ella: AI agents
MCP Server
Ella: AI Agents
Governance agent
Triage & resolution agent
Test recommendation agent
Catalog agent
Performance & cost agent
Anomaly Detection Monitors
Monitors overview
Automated monitors
Configuration and Feedback
Metrics
Data Testing
Data Tests
Overview and configuration
dbt tests
Custom SQL test
Schema validation
Managing test coverage
Data Lineage
Lineage overview
Column level lineage
Lineage to BI
Alerts and Incidents
Alerts & incidents overview
Setup & configure alerts
Incidents
Incident management
Performance & Cost
Performance monitoring
Performance alerts
Data Governance
Governance for observability
Critical Assets
Manage metadata
AI descriptions (Beta)
Collaboration & Communication
Data Observability Dashboard
Data Health Scores
Data Catalog
MCP Server
MCP overview
MCP setup guide
MCP tools
Additional features
Configuration-as-Code
Multiple Environments
Elementary CI
User activity logs
Guides
Setup Elementary
Environment Syncs Schedule
Collect jobs data
dbt source freshness
Troubleshooting
Integrations
All integrations
Data warehouses
Transformation & Orchestration
Data visualization
Reverse ETL
Code repositories
Alerts & Incidents
Data Catalog
Security and Connectivity
Resources
Cloud vs OSS
Best Practices Guide
Pricing
Community
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.
Suggest edits
Raise issue
Custom SQL test
Managing test coverage
Assistant
Responses are generated using AI and may contain mistakes.