v0.210.0

✨ Features

• Dbt cli skeleton (#5118) @erindru
• Dev-only VDE mode (#5087) @izeigerman
• Re-introduce merge for updating auto restatements (#5112) @vchan
• Cancel submitted BigQuery jobs on keyboard interrupts (#4979) @georgesittas
• (vscode) Adding validation to config (#5126) @benfdking
• Propagate ignore_cron into plan (#5152) @izeigerman
• Yaml config for dbt projects (#5156) @erindru
• (dbt) Add support for dbt debug macro (#5160) @themisvaltinos
• (vscode) Multi project for vscode (#5084) @benfdking
• Function to get range of key/value in model block (#5119) @benfdking
• (vscode) Add the Table Diff view in the extension (#4917) @themisvaltinos
• Add ignore destructive support (#5117) @eakmanrq
• (dbt_cli) Add support for '--profile' and '--target' (#5174) @erindru
• (dbt) Add dbt graph context variable support (#5159) @themisvaltinos
• Add support for Microsoft Fabric Warehouse (#4751) @fresioAS
• (dbt) Add support for adapter.rename_relation (#5188) @vchan
• Create physical tables as part of evaluation (#5189) @izeigerman
• Print auto-restatement triggers in debug console (#4980) @treysp
• Add on_additive_change support (#5193) @eakmanrq

🪲 Bug fixes

• Add model default audits in the model preserving their args (#5106) @themisvaltinos
• Mark vars referenced in metadata macros as metadata (#4936) @georgesittas
• Migration script name @izeigerman
• Skip cleanup of missing physical tables (#5150) @izeigerman
• Sqlmesh.dbt.adapter.RuntimeAdapter.get_columns_in_relation() (#5115) @newtonapple
• Show optimized_query, column_definitions in diff (#5151) @georgesittas
• BigQueryEngineAdapter.get_table_schema() mypy error (#5153) @newtonapple
• Selector use provided models and fix mypy (#5148) @eakmanrq
• Support of recursive symlinks in dbt project folders (#5164) @izeigerman
• Warn instead of fail on incompatible incremental strategy for dbt models with a unique key (#5166) @izeigerman
• Properly load dbt relation type for get_relation() and related functions (#5144) @newtonapple
• Support aliases for the password field in dbt target config (#5167) @izeigerman
• (dbt) Use the info to control logging for dbt log builtin (#5140) @themisvaltinos
• Adding common to pnpm workspaces (#5170) @benfdking
• Use csv header as the primary source for column names when converting dbt seeds (#5173) @izeigerman
• Broken link in docs (#5175) @serkef
• Remove leftover forward-only category usage when categorizing orphaned snapshots (#5190) @izeigerman
• Use drop cascade in janitor (#5133) @erindru
• Ignore datetime column parsing erros when rendering seeds (#5199) @izeigerman
• Fix snowflake int tests (#5198) @izeigerman

🛠️ Refactor

• Remove feature flags (#5165) @tobymao

🧹 Chore

• (vscode) Reenable quickfix test (#5120) @benfdking
• Info instead of warn for conditional properties assignment (#5122) @themisvaltinos
• (vscode) Reenable multi workspace tests (#5124) @benfdking
• (vscode) Removing legacy format methods (#5125) @benfdking
• (vscode) Reeenable find audit references test (#5123) @benfdking
• Adding shared ui setup (#5127) @benfdking
• Chore(web,vscode): adding npm publish shared package (#5128) @benfdking
• Fix publish job for shared code (#5129) @benfdking
• Add repository info to common code (#5130) @benfdking
• Add qa reviewer agent (#5131) @eakmanrq
• GCP Postgres integration tests (#5143) @vchan
• Validate start and end dates during plan build time (#5100) @themisvaltinos
• (vscode) Fix test stability (#5145) @benfdking
• Optimize snapshot unpausing @izeigerman
• Bump sqlglot to v27.7.0 (#5149) @georgesittas
• Chore(deps-dev): bump @testing-library/dom from 10.4.0 to 10.4.1 (#5094) @dependabot[bot]
• (deps) Bump actions/checkout from 4 to 5 (#5136) @dependabot[bot]
• (deps) Bump actions/create-github-app-token from 1 to 2 (#5135) @dependabot[bot]
• Optimize snapshot unpausing (#5147) @izeigerman
• (web_common) Rename folder (#5142) @mykalmax
• (web_common): update web common release file (#5161) @mykalmax
• (web_common) Add base styling + storybook (#5163) @mykalmax
• Bump sqlglot to v27.8.0 (#5185) @georgesittas
• (deps) Bump @tanstack/react-router-devtools from 1.129.8 to 1.131.26 (#5180) @dependabot[bot]
• Allow forks run private repo tests (#5176) @eakmanrq
• (fabric) Enable integration tests (#5192) @erindru

👽 Other

• Partial restatements for SCD type 2 models (#5138) @themisvaltinos
• Revert "Chore!: Optimize snapshot unpausing" @izeigerman
• (dbt) Update for yaml config (#5169) @erindru
• Clarify plan vs. run behavior of blocking audits (#5197) @treysp

v0.209.1

🪲 Bug fixes

• Remove leftover forward-only category usage when categorizing orphaned snapshots (#5190) @izeigerman

v0.209.0

✨ Features

• Decouple forward-only from change categorization (#5110) @izeigerman

🪲 Bug fixes

• Do not initialize a state sync for sqlmesh clean (#5103) @VaggelisD

🧹 Chore

• Fix dbt incremental predicates test (#5113) @themisvaltinos

v0.208.1

🪲 Bug fixes

• Revert "Fix: Use merge when updating auto restatements (#5016)" (#5108) @vchan

v0.208.0

✨ Features

• Add ui package to keep sharable components and utils (#5089) @mykalmax

🪲 Bug fixes

• Make gateway names case-insesitive (#5092) @izeigerman
• Support Paren expressions in EACH, REDUCE, etc macros (#5096) @izeigerman
• Dont normalize aliases in merge and when matched (#5014) @themisvaltinos
• Migrate schemas when deploying a metadata snapshot that was based on unpromoted forward-only snapshot (#5102) @izeigerman

🧹 Chore

• Introduce Claude subagents to the repo (#5093) @izeigerman
• Add private repo tests on pr (#4972) @eakmanrq

👽 Other

• Clarify note about interval-scoped audits for incremental by time (#5101) @treysp

v0.207.0

✨ Features

• Helper to find key in model block (#5079) @benfdking
• Lint rule no missing external will create file (#5078) @benfdking
• Handle additional pseudocolumn types in bigquery when resolving… (#5085) @z3z1ma

🪲 Bug fixes

• Normalize blueprint variables (#5045) @georgesittas
• (athena) Properly extend Athena dialect (#5077) @erindru
• Clean signal registry before loading signals for the given project (#5088) @z3z1ma
• Unit test CTE failures not being captured (#5081) @VaggelisD

🧹 Chore

• Bump sqlglot to 27.6.0 (#5090) @izeigerman

👽 Other

• Clarify multiple signals must all be true (#5086) @treysp

v0.197.7

🪲 Bug fixes

• Don't use SCD type 2 restatement logic in regular runs (#4976) @themisvaltinos

v0.206.1

✨ Features

• (vscode) Allow the lsp loaded to be specified (#5070) @benfdking

🪲 Bug fixes

• Resolve physical tables correctly when the query optimization is disabled for a model (#5074) @izeigerman

🧹 Chore

• (vscode) Reenabling tests (#5071) @benfdking
• (vscode) Enabling more tests (#5073) @benfdking

v0.206.0

✨ Features

• Add partitioning for ducklake databases (#5030) @treysp
• (vscode) Add test recognition to vscode (#5019) @benfdking
• Location in nomissingexternal models linting error (#5049) @benfdking
• (vscode) Adding ability to update columns (#5013) @benfdking
• Allow the linter to return fixes that affect other files (#5057) @benfdking
• Allow empty external models file (#5061) @benfdking
• No missing external model provides fix (#5058) @benfdking

🪲 Bug fixes

• Stopped server would just restart (#5051) @benfdking
• Inconsistent behaviour when a macro returns a list containing a single array vs multiple arrays (#5037) @erindru
• (vscode) Force lsp to be single worker (#5050) @benfdking
• (vscode) Improve registering of lsp in extension (#5056) @benfdking
• Table_naming_convention not passed in all cases (#5062) @erindru
• Respect the project configuration if the forward-only suffix was not set in the bot's config (#5064) @izeigerman

🧹 Chore

• Log rendered jinja right before parsing it to improve debugging (#5043) @georgesittas
• (vscode) Move tests to central temp dir creation (#5054) @benfdking
• Remove unused variable (#5055) @benfdking
• Print a deprecation warning in the sqlmesh ui command (#5046) @izeigerman
• (docs) Fix-broken-link-to-example-file (#5048) @gem7318
• Ensure ducklake testing artifact is under a tmp path (#5059) @georgesittas
• Pin dateparser version (#5063) @erindru
• Bump sqlglot to v27.5.1 (#5068) @georgesittas

👽 Other

• Fix syntax error in linter guide (#5052) @treysp
• (vscode) Be less aggressive in CI (#5053) @benfdking

v0.205.0

✨ Features

• Allow linter to return multiple violations (#5026) @benfdking
• Allow some control of table naming at the physical layer (#4982) @erindru

🪲 Bug fixes

• Suppor forward-only changes of model kinds under certain circumstances (#5028) @izeigerman
• Revert dbt full_refresh handling for incremental by time range models (#5031) @izeigerman

🛠️ Refactor

• (lsp) References now use paths (#5036) @benfdking
• (lsp) Move references to internal types (#5039) @benfdking

🧹 Chore

• Bump sqlglot to v27.4.1 (#5035) @georgesittas
• Fail if >1 migration scripts start with the same version (#5038) @georgesittas
• (vscode) Turn on trace to help debug (#5041) @benfdking