Sqlmesh

:sparkles: Features
* Fully Qualify Models and Tables with Connection Catalog (1574) eakmanrq
* When using Airflow source the default catalog from Airflow variables (1859) izeigerman
* Cicd bot add include_unmodified (1885) eakmanrq
* CI/CD Capture Console Errors (1888) eakmanrq
* Use sqlglotrs by default (1903) tobymao
* Add config for view catalog (1899) eakmanrq
* Bind the plan end to the current end of the target environment (even for prod) (1906) izeigerman
* Explicitly label preview backfills in the plan summary (1912) izeigerman
* Add full snowflake private key support (1911) eakmanrq

:beetle: Bug fixes
* Cicd bot duplicate model names in output (1852) eakmanrq
* Add test connection (1854) eakmanrq
* Logging for notebooks tobymao
* Make logging more intuitive to use (1860) tobymao
* Use columns to types only if model is annotated in tests (1868) georgesittas
* Improve error logging for common config import errors. currently we eat errors and they are useless, debug flag doesn't work because this happens before logging gets configured (1870) tobymao
* Hide loading message after lineage ready (1862) mykalmax
* Revert dbt columns change because the signatures don't match for bigquery (1873) tobymao
* Scheduler imports tobymao
* Z-index for context menu (file-explorer) (1869) mykalmax
* Fix Transactions with Truncate (1880) eakmanrq
* Properly quote set catalog (1882) eakmanrq
* Improve the condition under which sqlmesh raises an error about snapshot being unrevertable (1879) izeigerman
* Fix trino catalog typo (1886) eakmanrq
* 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
* Missing quote duckdb (1889) eakmanrq
* Handle 0 batch_size in select_from_values (1883) vchan
* Cache default catalog (1890) eakmanrq
* Delete associated records in the '_seeds' table when deleting a snapshot (1896) izeigerman
* Add back default catalog in cache entry id (1897) eakmanrq
* Always set the varchar size when creating a table in redshift (1881) izeigerman
* Only apply the CTAS workaround in redshift if LIMIT is set to 0 (1898) izeigerman
* Cancel apply in UI (1892) vchan
* Send fqn when requesting column lineage (1893) mykalmax
* Don't send sqlmesh type with files, and handle that independently on ui (1894) mykalmax
* Add more caching to intervals and cron (1905) tobymao
* Adopt and display fqn (1876) mykalmax
* Set the correct start timestamp for a plan with restatements in the presence of missing intervals (1909) izeigerman
* Run reload_context in file watcher in executor (1910) mykalmax
* Update overview stage (1891) mykalmax
* Failure to log expression on jinja error tobymao
* Caching sub-second accuracy (1914) eakmanrq
* Only sqlglot format sql files (1916) eakmanrq
* Allow dbt projects to override generate_alias/database/schema_name and source macros (1574) crericha
* Normalize sql input from dbt adapter calls (1574) crericha
* Detect dbt project macro dependencies missed by dbt manifest parser (1574) crericha

:broom: Chore
* Upgrade slqglot v20.3 (1853) tobymao
* Fix pydantic warning (1857) eakmanrq
* More perf improvements by allowing caching of unrenderable queries tobymao
* Support verbose CLI output for the 'plan' command (1855) izeigerman
* Return 204 on empty reuqest (1867) mykalmax
* Clean up plan action (1865) mykalmax
* Handle auto_apply option (1866) mykalmax
* Remove the ability to run CLI files as scripts (1877) vchan
* Improve env status display (1861) mykalmax
* Clean up dead code related to old version CLI command (1895) georgesittas
* Fix typing latest pandas-stub (1902) eakmanrq
* Redshift cleanup incorrect set catalog (1901) eakmanrq
* Move shared objects to shared.py (1900) eakmanrq
* Make set catalog class decorator (1904) eakmanrq

:alien: Other
* Revert "chore: more perf improvements by allowing caching of unrenderable queries" tobymao
* Reapply "chore: more perf improvements by allowing caching of unrende… (1858) tobymao
* Describe snowflake connection for lowercase object (1864) treysp
* Quote duckdb alias (1871) eakmanrq
* Add custom measures to observer guide (1856) treysp

:beetle: Bug fixes
* Always set the varchar size when creating a table in redshift (1881) izeigerman
* Only apply the CTAS workaround in redshift if LIMIT is set to 0 (1898) izeigerman
* Fix Transactions with Truncate (1880) eakmanrq
* Delete associated records in the '_seeds' table when deleting a snapshot (1896) izeigerman

: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