v0.222.0

✨ Features

• Bring dbt node information through to SQLMesh (#5412) @erindru

🪲 Bug fixes

• Support seed model schema changes in dev-only VDE mode (#5419) @izeigerman
• Bigquery snowflake source columns support (#5428) @eakmanrq
• Sort nested AttributeDict's to prevent visual diff (#5397) @erindru
• Warn on dbt variable definition failure instead of raising (#5427) @georgesittas

🧹 Chore

• Bump sqlglot to v27.17.0 (#5429) @georgesittas
• Break up the core integration tests (#5432) @izeigerman
• Remove dead code @izeigerman

v0.221.2

🪲 Bug fixes

• Disable WAP support by default for Spark and Iceberg (#5415) @izeigerman
• Reporting deletion of physical tables for snapshots of symbolic / audit models (#5422) @izeigerman
• Lowercase column names snowflake (#5425) @eakmanrq

🧹 Chore

• Fix dbt ci tests (#5426) @eakmanrq
• Fix tests to include dataframe (#5423) @eakmanrq

v0.221.1

🪲 Bug fixes

• Traverse target snapshots instead of all snapshots (#5416) @eakmanrq
• Pass a copy of the properties to avoid mutation of actual dict (#5417) @themisvaltinos

v0.221.0

🪲 Bug fixes

• Ignore cluster_by config for embedded model kind (#5409) @toriwei
• Adapt test to use thread specific consoles (#5414) @themisvaltinos
• Exempt seed models from migration (#5413) @izeigerman

🧹 Chore

• Bump sqlglot to v27.16.2 (#5403) @georgesittas

v0.220.2

🪲 Bug fixes

• Dont backfill seeds if the seed data didnt actually change (#5398) @erindru
• Remove need for uvicorn (#5394) @benfdking
• Load dbt model containing only a comment and non-sql jinja (#5368) @treysp
• Tests should not be sensitive to output column order (#5369) @treysp
• Support auto_restatement_cron in python models (#5141) @treysp
• Include pre/post when cloning (#5405) @eakmanrq
• (dbt) Update dispatch signature to match dbt method (#5410) @themisvaltinos

🧹 Chore

• Pin cryptography instead of leaving it to the resolver (#5401) @themisvaltinos

v0.220.1

🪲 Bug fixes

• Make table schema migration retriable (#5395) @izeigerman

🧹 Chore

• Chore include dev only vde in engine integration test (#5396) @izeigerman

v0.220.0

✨ Features

• (sqlmesh_dbt) Implement --full-refresh (#5370) @erindru

🪲 Bug fixes

• Create empty physical tables for fully annotated self-referential models (#5391) @izeigerman

🧹 Chore

• Bump sqlglot to v27.15.2 (#5393) @georgesittas

v0.219.0

✨ Features

• Add catalog type overrides (#5382) @eakmanrq
• Improve CLI and --explain output for restatements (#5348) @erindru

🪲 Bug fixes

• (web_common) Loading icon size (#5378) @mykalmax
• Modifying a standalone audit when using the dev-only virtual environment mode (#5383) @izeigerman
• Regression that caused view snapshos not to be migrated (#5389) @izeigerman

🧹 Chore

• Refactor to remove merge mixin (#5380) @eakmanrq

v0.218.0

✨ Features

• Prevent other processes seeing missing intervals during restatement (#5285) @erindru

🪲 Bug fixes

• When restating prod, clear intervals across all related snapshots, not just promoted ones (#5274) @erindru
• Normalize unit testing fixture catalog (#5343) @georgesittas
• (databricks) Materialized view drop failure due to incorrect type (#5351) @themisvaltinos
• Dbt prevent all cycles from tests (#5345) @eakmanrq
• Include warehouse in dbt target attribute dict (#5356) @georgesittas
• Match dbt behavior to ignore partition_by for views (#5359) @toriwei
• Add missing ref (#5361) @mykalmax
• Don't consume connected tokens when parsing quoted identifiers (#5357) @georgesittas
• Add package to peer deps (#5363) @mykalmax
• The resolution order for dbt variables (#5366) @izeigerman
• Update dbt loader to support loading multiple models from same file (#5346) @crericha
• Dbt manifest can have null macro dependencies that translate into 'None' (#5367) @crericha
• Port sqlglot pipe syntax fix in _parse_select (#5373) @georgesittas
• Adjust styling for component (#5375) @mykalmax
• Treat all instances of macro variables as case-insensitive (#5352) @georgesittas
• Variable overrides for dbt packages (#5376) @izeigerman

🧹 Chore

• Improve cycle detection error (#5338) @eakmanrq
• (web_common) Move more shared components (#5320) @mykalmax
• Make column_descriptions validation more lenient (#5354) @georgesittas
• Update row test bc redshift now uses CTAS (#5344) @treysp
• (web_common) Export components with types (#5347) @mykalmax
• Bump sqlglot to v27.14.0 (#5360) @georgesittas
• Add pre and post hook to dbt fixture (#5372) @benfdking

v0.209.3

🪲 Bug fixes

• Remove ensure no forward-only revert check @izeigerman