v0.227.1

🪲 Bug fixes

• Require the cache for upstream deps in the scheduler (#5571) @izeigerman

v0.227.0

✨ Features

• Check freshness for mixed external & sqlmesh models (#5499) @VaggelisD

🪲 Bug fixes

• Do not reduce empty generator when evaluating snapshots (#5548) @georgesittas
• Unexpected backfill of a parent when an interval outside the parent's range is restated for a child (#5551) @izeigerman
• Create_test error with query and CTEs included (#5559) @treysp
• Incorrect treatment of the model's table as missing when processing batches with index > 0 (#5560) @izeigerman
• Only selected models need to be promoted when --inlclude-unmodified flag is provided (#5561) @izeigerman
• Added missing execution_time param for CLI audit command (#5563) @makaroni4
• Cache upstream dependencies when building the evaluation DAG in scheduler (#5569) @izeigerman
• Temporary disable lsp benchmarks @izeigerman
• Make macro evaluator locals available from macro calls in jinja (#5568) @crericha

🧹 Chore

• Bump sqlglotrs to 27.28.0 (#5556) @georgesittas

v0.226.0

✨ Features

• (sqlmesh_dbt) Add support for --log-level (#5514) @erindru
• (web_common) Make simpler including common package directly within repo (#5523) @mykalmax
• (sqlmesh_dbt) Add support for --project-dir and --profiles-dir (#5524) @erindru

🪲 Bug fixes

• Add default (empty) tags to dbt builtin globals config (#5506) @newtonapple
• (web_common) Add more generic type for cll components (#5505) @mykalmax
• Robust cluster_by config parsing (#5478) @geooo109
• (windows) Allow 'sqlmesh clean' to delete cache file paths that exceed 260 chars (#5512) @erindru
• Mask credentials in duckdb attach for postgres, mysql logging (#5528) @themisvaltinos
• Ensure dbt BigQueryConfig dataset & project are set (#5526) @newtonapple
• Check whether the expired snapshot is among previously finalized snapshots if the environment is not finalized (#5521) @izeigerman
• (web_common) Simplify layout component (#5533) @mykalmax
• Ignore constraints in dbt seed column types (#5535) @geooo109
• Allow expressions in scd type 2 models columns, check_cols in dbt (#5529) @themisvaltinos
• (web_common) Add title to control button (#5540) @mykalmax
• (web_common) Use layout hook (#5541) @mykalmax
• (table_diff) Widen the data types that --decimals applies to (#5542) @erindru
• Dbt as_bool and as_number filters should return their original input values (#5532) @newtonapple
• Include schema temp table (#5545) @eakmanrq
• Respect mssql_merge_exists flag and use merge as a strategy (#5544) @themisvaltinos
• Ensure _get_data_objects respects snapshots with different schemas (#5515) @z3z1ma
• Add dbt-core 1.2.0 support (#5547) @crericha

🧹 Chore

• Improve unit test validation (#5517) @georgesittas
• Add tag assertion in selectors tag test (#5518) @themisvaltinos
• Small dbt test addition (#5519) @benfdking
• Add the max identifier length to the mssql adapter (#5527) @themisvaltinos
• Fix dbt test flakiness (#5530) @eakmanrq
• Fix flaky test when profiles yaml might exist (#5536) @themisvaltinos
• Ignore partition_by config if dialect is snowflake (#5522) @toriwei

v0.225.0

✨ Features

• (dbt) Add support for dbt custom materializations (#5435) @themisvaltinos
• (sqlmesh_dbt) Implement --model and --resource-type (#5443) @erindru
• (web_common) Add components for lineage (#5385) @mykalmax
• (web_common) Add option to toggle node dragging in lineage (#5473) @mykalmax
• (experimental) Add official support for model grants (#5275) @newtonapple
• (dbt) Add support for transaction in dbt pre and post hooks (#5480) @themisvaltinos
• Add batch_concurrency to ModelDefaultsConfig (#5481) @etonlels
• (sqlmesh_dbt) Support the --threads CLI option (#5493) @erindru
• (experimental) Add grants support for DBT custom materializations (#5489) @newtonapple
• Add config flag to infer the state schema per dbt target (#5485) @erindru
• Batch expired snapshots (#5486) @eakmanrq
• Add dbt builtin global try_or_compiler_error (#5504) @treysp

🪲 Bug fixes

• Pop 'begin' model config for all model kinds (#5453) @treysp
• Ignore partition_by field for ephemeral models (#5454) @toriwei
• Support unicode characters in file cache (#5463) @eakmanrq
• Dont try to serialize engine adapter to sql in macro template method (#5455) @z3z1ma
• Use bitnami legacy for spark (#5470) @georgesittas
• Unicode in model name databricks (#5465) @eakmanrq
• (web_common) Adjust types in lineage component (#5476) @mykalmax
• Parse column from cast expression for ScdType2 models (#5475) @toriwei
• (web_common) Make styling in some components more flexible (#5482) @mykalmax
• (web_common) Fix layout update (#5483) @mykalmax
• (web_common) Clean up lineage layout component (#5487) @mykalmax
• (web_common) Apply className and update stories (#5488) @mykalmax
• Unique, user-friendly audit names for custom named dbt tests (#5484) @treysp
• Add workaround to ignore source dependency if fqn matches model (#5492) @crericha
• (web_common) Lineage styling and border colors (#5494) @mykalmax
• Account for missing stdin / stdout when checking whether the runtime environment is interactive (#5500) @izeigerman
• Validate data_type for partition_by config (#5491) @toriwei
• Remove state sync from migrate (#5502) @eakmanrq
• Track shadowed jinja variable assignments correctly (#5503) @treysp
• Only keep refs and sources that exist to match dbt load time behaviour (#5509) @themisvaltinos

🧹 Chore

• Add fields to dbt jinja target variable (#5449) @treysp
• Bump sqlglot to v27.20.0 (#5460) @georgesittas
• Add Makefile command to recursively clean .cache dirs (#5471) @georgesittas
• Rename clean-caches to clear-caches (#5472) @georgesittas
• Cache results of get_data_objects (#5467) @izeigerman
• Make .sqlmesh location configurable (#5474) @georgesittas
• Make console width deterministic in tests (#5477) @georgesittas
• Fix flaky test by unliking dbt msgpack for deterministic behaviour (#5479) @themisvaltinos
• Fix windows tests (#5496) @erindru
• Fix typo in dbt error message (#5507) @themisvaltinos
• Bump sqlglot to v27.22.0 (#5508) @georgesittas
• Move janitor functions to janitor.py (#5510) @eakmanrq

v0.224.0

✨ Features

• Categorize indirect MV changes as breaking for seamless version switching (#5374) @xardasos
• Skip model evaluation if upstream external model(s) have not changed (#5277) @VaggelisD

🪲 Bug fixes

• Route linter warnings correctly in github output (#5441) @treysp
• Prevent duplicate audit names (#5431) @toriwei
• Normalize audit canonical name (#5448) @toriwei

🧹 Chore

• Bump SQLGlot to v27.19.0 (#5446) @eakmanrq
• Add dbt unit tests to fixture (#5451) @benfdking

v0.223.0

✨ Features

• (sqlmesh_dbt) Select based on dbt name, not sqlmesh name (#5420) @erindru

🪲 Bug fixes

• Include root package in search candidates when resolving dbt macros (#5349) @vchan
• Include forward_only parsed snapshot (#5442) @eakmanrq

🧹 Chore

• Bump sqlglot to v27.18.0 (#5439) @georgesittas

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