Sqlmesh

:sparkles: Features
* Detect circular references from dbt tests (1822) crericha

:beetle: Bug fixes
* Include macro dependencies missed by dbt manifest parser (1836) crericha
* Build UI before wheel (1838) vchan
* Add rust tokenizer support with new parser (1835) tobymao
* Parse errors with upgrade (1840) tobymao
* Fix pendulum dependency (1847) eakmanrq
* Do not load environments just to get their naming info (1843) vchan
* Dialect dropdown + include_unmodified (1839) mykalmax
* Macros resolution inside lambdas (1849) tobymao

:broom: Chore
* Add plan action class to control plan flow (1827) mykalmax
* Attempt to fix the Airflow build izeigerman
* **(docs)** Add columns model property to docs (1841) treysp
* Do not load a context when starting the UI (1842) vchan
* Show loading when waiting for files to load (1845) mykalmax
* Log and send SSE updates after each stage completion for plan_overview (1846) mykalmax
* Display ellipsis for long model names (1844) mykalmax

:alien: Other
* Add API to python api reference page title (1834) treysp
* Add model selection guide (1818) treysp

: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