在推出之前使用 SQLMesh 计划和预览仓库 SQL 模型变更
Compare SQL model changes, preview backfills and downstream impact, and stage safer warehouse rollouts before execution.
Prerequisites
Python 3.9+, pip, SQLMesh, warehouse connection
Installation
Use the upstream install or setup path that matches your environment:
- pip install 'sqlmesh[lsp]' # install the sqlmesh package with extensions to work with VSCode
Requirements and caveats from upstream:
- SQLMesh is a next-generation data transformation framework designed to ship data quickly, efficiently, and without error. Data teams can run and deploy data transformations written in SQL or Python with visibility and...
- python -m venv .venv
- Note: You may need to run python3 or pip3 instead of python or pip, depending on your python installation.
Basic usage or getting-started notes:
- # run the unit test
- 'new_column' AS new_column, / non-breaking change example /
- Track what data’s been modified and run only the necessary transformations for incremental models
- Source: https://github.com/1991513ccie-png/skills
- Extracted from upstream docs: https://raw.githubusercontent.com/SQLMesh/sqlmesh/HEAD/README.md
Documentation
- https://sqlmesh.readthedocs.io/
