sqlmesh
https://github.com/tobikodata/sqlmesh
Python
Efficient data transformation and modeling framework that is backwards compatible with dbt.
Triage Issues!
When you volunteer to triage issues, you'll receive an email each day with a link to an open issue that needs help in this project. You'll also receive instructions on how to triage issues.
Triage Docs!
Receive a documented method or class from your favorite GitHub repos in your inbox every day. If you're really pro, receive undocumented methods or classes and supercharge your commit history.
Python not yet supported1 Subscribers
Add a CodeTriage badge to sqlmesh
Help out
- Issues
- Table-Value Function (TVF) support for BigQuery
- Need to Make ClickHouse Cloud-Mode an Option
- The command create_external_models returns incomplete results for Databricks
- added support for iceberg tables on S3 table buckets using athena engine
- [Fabric/TSQL] Removed models persist in state snapshot when using `virtual_environment_mode = "dev_only"`
- BigQuery `JSON_KEYS` transpiles to `J_S_O_N_KEYS_AT_DEPTH` in DuckDB (missing generator transform)
- VSCode Extension: SQLMesh LSP crashes on startup: ImportError: cannot import name 'WorkspaceDiagnosticRefreshRequest' with lsprotocol 2025.x
- Model is missing but sqlmesh plan/run is successful
- Models with custom materialization cannot be deleted
- SCD_TYPE_2_BY_COLUMN: opt-in strict attributes on close (no COALESCE(target, source) for updated_rows)
- Docs
- Python not yet supported