Sqlmesh

: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

:sparkles: Features
* Run-all bot command errors if anything within it errors (3262) eakmanrq

:beetle: Bug fixes
* **(clickhouse)** Remove fractional seconds when time column is datetime/timestamp type (3261) treysp

:broom: Chore
* Clarify that restatement plans ignore local changes (3257) crericha

:alien: Other
* Ensure using project instead of execution project for temp table as default (3249) Kayrnt

:beetle: Bug fixes
* Refactor table part parsing for Snowflake (3254) georgesittas
* Always warn when an audit has failed (3255) georgesittas

:broom: Chore
* Bump sqlglot to v25.25.1 (3256) benfdking

:alien: Other
* Adding markdown feature to model description (3228) Harmuth94