Sqlmesh

:beetle: Bug fixes
* Remove trailing whitespaces in the JINJA_STATEMENT and JINJA_QUERY body (1884) izeigerman
* Only delete the snapshot temp table if no other snapshot uses the same temp version (1887) izeigerman
* Improve the condition under which sqlmesh raises an error about snapshot being unrevertable (1879) izeigerman

:broom: Chore
* Bump sqlglot to 20.3.0 izeigerman

:beetle: Bug fixes
* Improve perf of model loading by reducing (1848) tobymao
* Deserialization of the when_matched attribute of the INCREMENTAL_BY_UNIQUE_KEY kind (1851) izeigerman
* Fix unions tobymao

:broom: Chore
* Add package management and docs sections to dbt integration docs. (1850) crericha

: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