Elementary home pagelight logodark logo
  • Get Started Now
  • Get Started Now
Elementary Cloud
dbt Package and Tests
Elementary OSS
  • Book a Demo
  • Join Slack
  • Getting Started
    • Introduction
    • Quickstart
    Cloud Platform
    • Introduction
    • Platform features
    • Integrations
    • Security and privacy
    • Ella: AI agents
    Ella: AI Agents
    • Governance agent
    • Triage & resolution agent
    • Test recommendation agent
    • Catalog agent
    • Performance & cost agent
    Anomaly Detection Monitors
    • Monitors overview
    • Automated monitors
    • Metrics
    • Configuration and Feedback
    Data Tests
    • Overview and configuration
    • dbt tests
    • Custom SQL test
    • Schema validation
    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
    Additional features
    • Configuration-as-Code
    • Multiple Environments
    • Elementary CI
    Guides
    • Setup Elementary
    • Send alerts
    • 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 editsRaise issue
    Custom SQL testLineage overview
    websiteslack
    Powered by Mintlify
    Assistant
    Responses are generated using AI and may contain mistakes.