Sqlmesh

:sparkles: Features
* Add dlt_refresh command to update models from a dlt pipeline (3340) Themiscodes
* Add support for recursive CTEs in unit tests (3351) georgesittas

:beetle: Bug fixes
* Support passing variables into python models as kw-only arguments (3350) izeigerman
* Always make dataframes hashable when comparing them in unit tests (3354) georgesittas

:broom: Chore
* Bump sqlglot to v25.30.0 (3358) georgesittas

:alien: Other
* Add section on empty DFs to python models concepts (3348) treysp
* Add missing options on info command (3349) Kayrnt

:sparkles: Features
* Add temp_schema option for table_diff (3311) Kayrnt
* Allow formatting specific models via path posargs for more typi… (3331) z3z1ma
* Expose batch_concurrency field for time range incremental dbt models (3341) georgesittas

:beetle: Bug fixes
* Add ruamel serializer for decimal.Decimal values (3333) georgesittas
* Bump sqlglot to v25.29.0, fix info schema view handling in bigquery (3332) georgesittas
* Decorator type erasure (3321) etonlels
* Adjustments to upgrade docs (3286) mykalmax

:broom: Chore
* Fix build (3334) erindru

:alien: Other
* Mkdocs.yml: add favicon (3337) unytics
* Add UI favicon to docs (3339) treysp
* Update Bigquery config reference (3343) treysp
* Update multi-repo docs (3344) Themiscodes

:sparkles: Features
* Add quota_project conf for dbt project support (3326) Kayrnt

:beetle: Bug fixes
* Enable fetching schema for models querying INFORMATION_SCHEMA (3324) georgesittas

:broom: Chore
* Address minor doc inaccuracies (3327) izeigerman
* Refactor context run and _run (3328) crericha

:beetle: Bug fixes
* Copy grants when replacing a view in snowflake (3318) izeigerman
* Only provide COPY GRANTS when replacing a view in Snowflake (3320) izeigerman

:broom: Chore
* Document time_data_type for scd type 2 model kinds (3315) eakmanrq
* Fix types in the Environment's property methods (3314) izeigerman
* Make it so duplicate snapshot push doesn't raise because this … (3323) tobymao

:alien: Other
* Add model config reference link to model kinds concepts (3319) treysp
* Clickhouse table/partition swapping (3291) treysp

:sparkles: Features
* Adding ability to specify table/view type (3253) benfdking
* **(clickhouse)** Use table/partition swap for insert-overwrite (3226) treysp
* Treat models with unaligned start as non-deployable insted of ignoring them (3295) izeigerman
* **(clickhouse)** Fall back to RENAME if EXCHANGE TABLES errors (3296) treysp
* Add support for model selector expressions to the run command (3305) izeigerman
* Support exit from the run command with a provided code when interrupted by an update to the target env (3307) izeigerman
* Add sqlmesh.lock and fix plans with only req changes (3299) tobymao
* Support the empty backfill mode for the plan command (3312) izeigerman

:beetle: Bug fixes
* Ensure table_diff works consistently with multiple join keys (3281) erindru
* Hardcode dateparser to use UTC so it works in environments where /etc/localtime may have been modified (3287) erindru
* Make sure that ignored models are not included in preview restatements (3292) izeigerman
* Correctly handle snapshot serde during migrate (3293) z3z1ma
* Small typo in output (3306) benfdking
* Only backfill models selected for restatement when restatements are provided (3308) izeigerman
* Skip creation call for tables that already exist (3304) Themiscodes

:broom: Chore
* Refactor flaky test (3294) georgesittas
* Publish dev builds merge to main (3105) eakmanrq
* Fix missing comma in private test trigger (3300) eakmanrq
* Remove bash env export for private tests (3301) eakmanrq
* Bump sqlglot to v25.28.0 (3303) esciara

:alien: Other
* Fix small list item error (3285) benfdking
* Troubleshooting snoflake repeated auth prompts (3284) benfdking
* Adding glossary term for virtual and physical layer (3283) benfdking
* Add secure and transient details for snowflake (3278) benfdking
* Use github README as docs frontpage (3290) treysp
* Trey/signals docs (3298) tobymao
* Add central docs about creatable_type (3302) benfdking
* Add dlt doc to navbar (3310) treysp

:sparkles: Features
* Create temp tables only when needed (3258) Themiscodes
* DuckDB extension config to support community extensions (3224) rubenvereecken
* Add python library versions to the environment (3275) tobymao

:beetle: Bug fixes
* Prevent extraction of dependencies from a rendered query for dbt models (3263) izeigerman
* Ensure Redshift's _fetch_native_df respects case-sensitivity (3266) georgesittas
* Ensure 'except' columns are always filtered out in star macro (3267) georgesittas
* Handle missing signals in built in scheduler closes 3094 (3265) tobymao
* Snowflake integration tests (3269) Themiscodes
* Support merging for Postgres version < 15 (3272) izeigerman
* Pass dialect to MD5 func builder in generate_surrogate_key macro (3273) georgesittas
* Set yesterday before plan for the Airflow end-to-end and integration tests (3271) Themiscodes
* **(athena)** Use 'catalog_name' as the default catalog (3274) erindru
* **(clickhouse)** Use DateTime64(6) type in incremental time filter (3268) treysp

:broom: Chore
* Bump sqlglot to v25.27.0 (3279) georgesittas