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