SQLMesh

Semantic Understanding

SQLMesh actually understands the SQL you write and improves developer productivity by finding issues at compile time. Built-in column-level lineage provides a deeper understanding of your data model and transpilation makes it easy to run your SQL across multiple engines.

Virtual Data Environments

Virtual Data Environments empower your data team to create dynamic representations of your data while ensuring tables are never built more than once. Unit tests, Audits, and Data Diff provide validation throughout your development workflow to make it easy to trust the datasets you produce.

Effortless Collaboration

Automated data contracts connect your entire data organization and make it easy to evolve together without data consistency issues. Open source CI/CD bot tells reviewers exactly what is changed in a given environment which reduces the overhead to reviewing a change.

Quality Deployments

Have confidence in the data you ship to production by deploying what has been validated and leveraging SQLMesh's automatic data-gap prevention. Even when mistakes do happen, SQLMesh seamlessly rolls back to the prior version allowing teams to reduce downtime in production.

SQLMesh UI

SQLMesh comes with a UI. You can develop your SQL, view lineage and dependencies, and manage your workflows. It's completely free and included in our open source package.

Works With The Tools You Use Today

Extensible at its core, we continue to add integrations. Join our community to help us shape our roadmap or make a contribution yourself!

Data Warehouse

Data Orchestration

dbt Compatibility

Run your dbt project as-is and unlock the power of SQLMesh: cut cloud bills with virtual data environments, understand pipelines with column-level lineage, collaborate safely with automatic data contracts, and deploy confidently with automated CI/CD.