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
- [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)
- SCD_TYPE_2: option to preserve existing physical table rows on new snapshot identifier (is_first_insert truncation)
- DuckLake: partitioned_by on INCREMENTAL_BY_UNIQUE_KEY results in unpartitioned files on initial build
- Chore(deps): Bump dorny/paths-filter from 3 to 4
- Chore(deps): Bump actions/download-artifact from 4 to 8
- Docs
- Python not yet supported