Releases: SQLMesh/sqlmesh
Releases · SQLMesh/sqlmesh
v0.189.0
✨ Features
- Render model without active editor (#4636) @benfdking
- Add ducklake
DATA_INLINING_ROW_LIMITattach option (#4635) @mrjsj - (vscode) Rerender on save model (#4637) @benfdking
- Clickhouse HTTPS config parameters (#4571) @treysp
- Remove module pandas import to improve import speed (#4631) @eakmanrq
- Add support for Trino's authorization session property (#4639) @georgesittas
- Lazy import numpy like pandas (#4653) @eakmanrq
- Lazy import duckdb (#4655) @eakmanrq
- Introduce plan explain mode (#4642) @izeigerman
🪲 Bug fixes
- (web) Incorrect encoding when viewing files containing non-ASCII characters (#4570) @codetalker-ai
- Set
OBJC_DISABLE_INITIALIZE_FORK_SAFETYfor macOS in CLI integration tests (#4644) @georgesittas - Ensure session-scoped Snowflake warehouse is rolled back on failure (#4640) @georgesittas
- Import pandas before loading in parallel to avoid macOS fork-related errors (#4647) @georgesittas
- Cicd bot correctly surface plan errors (#4646) @eakmanrq
- (cicd) Better handle model failures in GitHub check output (#4648) @erindru
- Support coercion of SQL literal expressions into literal types for macro arguments (#4643) @izeigerman
🛠️ Refactor
- (lsp) Move autocomplete functions about (#4603) @benfdking
🧹 Chore
- (deps) Bump zod from 3.25.28 to 3.25.48 (#4624) @dependabot[bot]
- (vscode) Reload project on save (#4602) @benfdking
- Add typing to vscode tooling files (#4626) @benfdking
- (lsp) Format test files (#4628) @benfdking
- (vscode) Add completions test (#4627) @benfdking
- (lsp) Run pnpm lock (#4629) @benfdking
- Update docs on
@this_model(#4599) @georgesittas - (lsp) Move autocomplete to the lsp (#4607) @benfdking
- Fix usage of cached properties in the Context (#4630) @izeigerman
- Bump sqlglot to v26.25.3 (#4650) @georgesittas
- Fix make style by adding correct pygithub version (#4651) @themisvaltinos
- Detect xdb diff syntax and raise early (#4654) @georgesittas
👽 Other
- (vscode) Support multiple workspaces (#4634) @benfdking
- Updating vsccode with features (#4611) @benfdking
v0.188.1
🪲 Bug fixes
- Adapt get_dbt_version tuple to include patch in version (#4619) @themisvaltinos
- Don't pass engine adapter dialect in test connection (#4618) @themisvaltinos
🛠️ Refactor
- (lsp) Refactor lsp calls into context (#4616) @benfdking
🧹 Chore
- (lsp) Introducing benchmark (#4601) @benfdking
- (vscode) Cleaning up setup and tests (#4610) @benfdking
- (vscode) For tests tell it to install extension (#4617) @benfdking
- Improve error message when no MODEL block (#4588) @treysp
- Improve plan error handling when --select-model is used and the remote snapshot can't be rendered (#4585) @erindru
- (deps) Bump @tanstack/react-router-devtools from 1.120.10 to 1.120.13 (#4621) @dependabot[bot]
- (deps) Bump @codemirror/view from 6.36.8 to 6.37.1 (#4620) @dependabot[bot]
👽 Other
- Add new security docs page (#4564) @afzaljasani
- Add data path and encrypted to duckdb catalog (#4600) @mattiasthalen
- Support displaying snowpark dataframes in notebooks. (#4572) @nickmuoh
v0.188.0
✨ Features
- (vscode) Gtd for macros (#4566) @benfdking
- (vscode) Rendered window is non-editable (#4591) @benfdking
- Make automatic python dependency inference opt-out (#4575) @georgesittas
🪲 Bug fixes
- (vscode) On startup pick the right model (#4556) @benfdking
- Catch errors caching optimized model queries so that SQLMesh can still load (#4532) @erindru
- Dependency handling when converting on-run-start / on-run-end hooks in dbt projects (#4567) @izeigerman
- (lsp) Fail gently on scope building failure (#4576) @benfdking
- Expand the 'tag:' selector based on local models and not remote ones (#4573) @erindru
- Ensure partial works when a query is used to produce data (#4583) @georgesittas
- Dbt-core 1.9.5 freshness error (#4586) @treysp
- (vscode) Render models without descriptions (#4593) @benfdking
- Only check if source snapshot is forward_only in table diff (#4592) @themisvaltinos
- Use memory gateway for LSP test to avoid creating actual db (#4594) @themisvaltinos
- Compare columns by using the schema differ based on snapshots dialect (#4595) @themisvaltinos
🛠️ Refactor
- Move engine adapter instantiation after loading on-demand (#4578) @themisvaltinos
🧹 Chore
- (vscode) Introduce pull first diagnostics (#4565) @benfdking
- (vscode) Set workers to 1 in e2e testing (#4579) @benfdking
- Clean up bigquery info. schema integration test (#4580) @georgesittas
- Fix flaky dbt test by grouping it with xdist (#4596) @themisvaltinos
- Bump sqlglot to v26.24.0 (#4598) @georgesittas
- (vscode) Add an integration test for gtd (#4608) @benfdking
👽 Other
v0.187.6
🧹 Chore
- Upgrade sqlglot to 26.21.1 @izeigerman
v0.187.5
🪲 Bug fixes
- (vscode) Protect from infinite loops (#4555) @benfdking
v0.187.4
🪲 Bug fixes
- Improve error handling for invalid environment connections (#4552) @georgesittas
- Support of vars in on-run-start / on-run-end hooks in dbt projects (#4554) @izeigerman
v0.187.3
🪲 Bug fixes
- Improve error handling when SQL model query is invalid (#4551) @georgesittas
- (vscode) Duplicate returned diagnostics (#4553) @benfdking
v0.187.2
v0.187.1
v0.187.0
✨ Features
- (vscode) Add info to hover (#4529) @benfdking
- Set query label session property in bq session (#4314) @ncbkr
- (vscode) Render model (#4533) @benfdking
- More cores for loading (#4427) @themisvaltinos
- (lsp) Add go to definition for ctes (#4543) @benfdking
🪲 Bug fixes
- (vscode) Fix installation of sqlmesh (#4526) @benfdking
- (snowflake) Correctly handle COPY GRANTS property in materialized views (#4518) @erindru
- Get rid of recursion when calculating skipped nodes (#4538) @izeigerman
- Ensure paths exist before treating them as relative (metaprogramming) (#4539) @georgesittas
- (mssql) Use truncate+insert for FULL models instead of merge (#4531) @erindru
- (lsp) Overwriting the formatted file (#4547) @benfdking
🧹 Chore
- Bump sqlglot to v26.20.0 (#4530) @georgesittas
- Document this_model and this_model_fqn (#4524) @georgesittas
- Make
default_connectionoptional (#4522) @VaggelisD - Ensure model search fails gracefully (#4535) @VaggelisD
- Add blueprint model to sushi (#4537) @benfdking
- Add nested cte to sushi for testing (#4540) @benfdking
- Bump sqlglot to v26.21.0 (#4541) @georgesittas
- Update node dependencies (#4542) @benfdking
👽 Other
- Add iceberg support to table_diff (#4441) @williebsweet