Releases: SQLMesh/sqlmesh
Releases · SQLMesh/sqlmesh
v0.216.0
✨ Features
- Add dedicated
incremental_by_time_rangestrategy (#5306) @eakmanrq - (state_sync) Add the ability to fetch all versions of a snapshot by name (#5273) @erindru
- Dbt microbatch ref filter support (#5292) @eakmanrq
🪲 Bug fixes
- Exclude bugged version of dbt-snowflake so pip resolves compatible version of dbt-adapters (#5313) @erindru
- Make sure builtin dbt macros can be referenced with the 'context.' prefix (#5308) @treysp
- Scd type 2 support table properties (#5317) @eakmanrq
🧹 Chore
- Split migration script implementations into DDL and DML (#5307) @izeigerman
- Remove the 'prompt' CLI command (#5310) @izeigerman
- Add singular test to dbt fixtures (#5315) @benfdking
- Remove old migration scripts up to and including v0060 (#5309) @izeigerman
v0.215.0
🪲 Bug fixes
- Match dbt handling of cluster_by config for view materializations (#5266) @crericha
- Ignore bigquery partition_by config when the target isn't bigquery (#5280) @crericha
- Ensure root package is treated top-level in dbt (#5290) @georgesittas
- (dbt) Respect the seed settings provided in the config of a dbt project (#5291) @themisvaltinos
- Depend on all attributes of dbt
modelwhen passed to a macro (#5269) @georgesittas - Make jinja-based model rendering more lenient (#5300) @georgesittas
- Add support for args syntax in dbt config (#5299) @themisvaltinos
- Prefetch all relevant data objects during snapshot migration (#5301) @izeigerman
- Dbt microbatch parameter conversion (#5298) @eakmanrq
- Allow partials by default for all models converted from a dbt project (#5303) @izeigerman
🧹 Chore
- Improve test stability and address some warnings (#5293) @erindru
- Bump sqlglot to v27.12.0 (#5302) @georgesittas
v0.214.0
✨ Features
- (dbt) Add config object to provide methods aligned with dbt (#5271) @themisvaltinos
🪲 Bug fixes
- Limit the number of fetched full snapshots when deleting expired snapshots (#5281) @izeigerman
- Complete lookback support for custom materializations (#5278) @georgesittas
- Make sure that changes to seed models are reflected in the dev-only VDE mode (#5282) @izeigerman
🧹 Chore
v0.213.1
v0.213.0
✨ Features
🪲 Bug fixes
- Avoid using rendered query when computing the data hash (#5256) @izeigerman
🧹 Chore
- Adding an analysis to dbt tests (#5276) @benfdking
- Add dbt microbatch interface (#5272) @eakmanrq
v0.212.0
✨ Features
- Support custom macros in dbt vars (#5250) @eakmanrq
- Dbt adapter allow invalid source ref for tests (#5259) @eakmanrq
- (dbt_cli) Set proper plan flags and also allow --empty and --environment (#5226) @erindru
🪲 Bug fixes
- Handle case where partition_by is explicitly passed in as None to dbt ModelConfig (#5240) @crericha
- Render
{% raw %}...{% endraw %}correctly (#5237) @georgesittas - Find variable node if nested (#5238) @eakmanrq
- Stop treating dbt schema data types as columns_to_types (#5231) @georgesittas
- (dbt_cli) Add global error handling group for dbt subcommands (#5239) @themisvaltinos
- (risingwave) Recreate materialized views (#5195) @VaggelisD
- Properly handle empty
varsmapping in dbt_project.yml (#5248) @georgesittas - Pydantic v1 issues with dbt 1.6 semantic models (#5255) @eakmanrq
- Update TestConfig limit type (#5257) @toriwei
- Automatically repair dbt test circular references by moving upstream test to downstream model (#5253) @crericha
- Regression in WAP support (#5264) @izeigerman
- Ignore extra keys in node config (#5265) @eakmanrq
- Evaluation of metadata snapshots with audit changes (#5267) @izeigerman
- Allow dbt models to be empty (#5270) @georgesittas
🧹 Chore
- Add integration test to verify before all execution order (#5241) @themisvaltinos
- Bump sqlglot to v27.9.0 (#5244) @georgesittas
- Add migration script to warn about dbt
data_type-related diffs (#5245) @georgesittas - Create make command install dbt version (#5251) @eakmanrq
- Improve adapter compatibility old dbt releases (#5252) @eakmanrq
- Address more integration test flakiness (#5258) @erindru
- Add heplful error message when drop operation fails (#5261) @themisvaltinos
- (web_common) Add more shared components (#5243) @mykalmax
- Allow duplicate keys in dbt project yaml files (#5254) @vchan
👽 Other
- Revert "Feat(experimental): DBT project conversion (#4495)" (#5246) @erindru
- Limit the vscode test job to 30mins (#5260) @benfdking
v0.209.2
🪲 Bug fixes
- Skip cleanup of missing physical tables (#5150) @izeigerman
v0.211.2
✨ Features
🪲 Bug fixes
- (dbt_cli) Make multiple --exclude's actually work (#5233) @erindru
- (vscode) Use url instead of endpoint for for consistent API fields (#5235) @themisvaltinos
- Handle whitespace trimming in dbt test-to-macro jinja normalization (#5232) @georgesittas
v0.211.1
✨ Features
🪲 Bug fixes
- Move before all statements execution before snapshot creation logic (#5229) @themisvaltinos
🧹 Chore
- Testing docs additions (#5221) @benfdking
- Reinstate test cli flag to false (#5230) @themisvaltinos
v0.211.0
✨ Features
- (dbt) Default to
virtual_environment_mode: dev_onlyon init (#5208) @erindru - Mimic dbt nuanced on_schema_change behavior (#5203) @eakmanrq
- (dbt) Add support for adapter.expand_target_column_types (#5206) @vchan
- Dbt adapter allow invalid ref for tests (#5207) @eakmanrq
- (dbt_cli) Add
--selectand--excludeoptions (#5200) @erindru - (dbt_cli) Add support for
--vars(#5205) @erindru
🪲 Bug fixes
- Intercept errors when loading the dbt manifest (#5214) @izeigerman
- Improve tracking of var dependencies in dbt models (#5204) @izeigerman
- Cleanup of materialized view snapshots (#5213) @izeigerman
- Check if the target table exists when determining the value of the is_incremental flag (#5215) @izeigerman
- Small fixes for seed models (#5217) @izeigerman
- (tests) Address some test flakiness (#5209) @erindru
- Catalog creation / deletion for motherduck (#5223) @izeigerman
- Make flat_graph a cached property (#5224) @izeigerman
🧹 Chore
- (web_common) Set up vitest with playwright and add tests for Badge cmp (#5210) @mykalmax
- (web_common) Add license to package.json (#5212) @mykalmax
- Fix dbt
referencesmanifest test (#5220) @georgesittas - (web_common) Fix version mismatch (#5222) @mykalmax
- (web_common) Move badge related css vars inside component and make css exportable (#5216) @mykalmax
- (web_common) Move colors in tailwind config (#5225) @mykalmax