Sqlmesh

:sparkles: Features
* Less aggressive formatting closes 1816 (1817) tobymao

:beetle: Bug fixes
* **(redshift)** Another attempt at hash fix tobymao
* Fix test tobymao
* Reduce the default dataframe batch size for the postgres engine adapter (1810) izeigerman
* Only log tests if you have any (1814) tobymao
* Fix cloud_composer scheduler config supported field validation (1820) vchan
* Support adding partial intervals for models with monthly interval unit (1824) izeigerman
* Bump orval versions and address typing issues (1821) mykalmax
* Workaround for weird date dtype bug exposed by duckdb v0.9.2 (1825) georgesittas
* Consider a model unannotated if it has columns with type NULL (1828) izeigerman
* Use default environment in notifications if no environment is specified for a run (1830) vchan
* Allow using model selector even if no environments were previously created (1831) izeigerman

:hammer_and_wrench: Refactor
* Improve query performance (1829) tobymao
* Use simplified gen to make data hash more performant (1832) tobymao

:broom: Chore
* Override the str representation of ExecutableKind (1811) vchan
* Upgrade sqlglot to v20 (1813) tobymao
* Upgrade sqlglot, replace table comments (1823) tobymao
* Use plan/apply api to trigger aysnc execution and wait for SSE (1826) mykalmax

:alien: Other
* Only update updated environments during migration (1805) vchan
* Remove graphviz and use html for dag gen (1812) tobymao
* Clarify lookback description (1819) treysp
* Don't use the global rng state in the order_items model (1833) izeigerman

:beetle: Bug fixes
* Skip null macro dependencies when extracting macro references from the dbt manifest (1808) izeigerman
* **(redshift)** Cast the children of aliases (1809) tobymao

:broom: Chore
* **(docs)** Document dbt runtime vars (1807) treysp

:beetle: Bug fixes
* Fix encode model names for lineage and wrong layer order for errors popup (1806) mykalmax

:alien: Other
* Add observer guide (1803) treysp

:sparkles: Features
* Improve logging (1778) tobymao
* Add flag to skip generating files in example project (1783) georgesittas
* Only backfill selected models unless explicitly stated otherwise (1788) izeigerman
* Redshift plan parsing to address ctas varchar(1) bug (1797) tobymao

:beetle: Bug fixes
* Preserve Array macro vars instead of converting them to Tuple (1781) georgesittas
* Fstring in cleanup tobymao
* Only dry run when necessary (1784) tobymao
* Only consider model snapshots when using selector (1787) izeigerman
* Take into account dbt vars, sources, and refs when computing snapshot fingerprint (1780) izeigerman
* Redshift svv_columns case (1791) eakmanrq
* Make redshift late binding again (1789) eakmanrq
* No_prompts should still show plan summaries, just have no prompts (1793) tobymao
* Use test engine adapter to compute output query in test gen (1796) georgesittas
* Set DataFrame column names explicitly in unit tests (1798) georgesittas
* The hadoop distro link in the airflow docker image izeigerman

:broom: Chore
* Bump sqlglot (1779) georgesittas
* Sushi integration tests for all engines (1770) treysp
* Add dialect test (1794) eakmanrq
* Improve readability of logs (1785) tobymao
* Fix patch ignore local config files (1795) eakmanrq
* **(docs)** Add column modification example to partitioned_by (1801) treysp

:alien: Other
* Pin pytest-asyncio (1802) vchan
* Small type fixed. (1804) richardgourley

:beetle: Bug fixes
* **(redshift)** Ctas now uses false limit 0 instead of from false propogation (1782) tobymao

:broom: Chore
* Simplify text_diff (1776) vchan

:sparkles: Features
* Support Iceberg format in the local Airflow setup (1755) izeigerman
* Cicd output check run conclusions (1752) eakmanrq
* Preliminary work to enable WAP support (1759) izeigerman
* Add support for duckdb extensions and connector config (1766) crericha
* Automate unit test generation (1756) georgesittas
* Expose snapshots to the MacroEvaluator (1761) georgesittas
* Add Iceberg WAP support to the Spark engine adapter (1769) izeigerman

:beetle: Bug fixes
* Run notifications (1757) vchan
* Few bugs during plan run/apply (1758) mykalmax
* Airflow tests izeigerman
* Plan flow and display tests (failed) (1751) mykalmax
* **(mssql)** Pymssql doesn't convert datetime.date objects (1745) treysp
* Redshift dbt connection timeout none (1771) eakmanrq
* Handle empty list in select_from_values_for_batch_range (1767) georgesittas
* Support for Pydantic >= 2.5 (1774) izeigerman
* Current catalog extraction across engines izeigerman
* Include sql statements in metadata hash. (1773) crericha
* Use expression for current catalog (1775) izeigerman

:broom: Chore
* Bump sqlglot to v19.7.0 (1763) georgesittas
* Increase timeout (1764) mykalmax
* **(docs)** Unify and use more expressive time_column names (1760) treysp
* Clean up plan component (1765) mykalmax
* Improve error message for rendering tobymao
* Pin Pydantic to <2.5.0 (1772) vchan