Sqlmesh

:sparkles: Features
* Skip croniter when possible for performance (1468) tobymao
* Allow evaluation of partial intervals (1451) izeigerman

:beetle: Bug fixes
* Ignore partial intervals when adding intervals to a snapshot (1466) izeigerman
* Fix : Restore selected env from local storage + add pinned envs to local list (1469) mykalmax
* Remove postgres materialized view support (1475) eakmanrq
* Move columns and rendered query to separate tabs in Editor inspector (1477) mykalmax
* Replace lock icon , relax zoom effect on lineage (1476) mykalmax
* Support standalone audits in the Airflow DAG generator izeigerman
* 1435 introduced invalid sql for querying the state sync (1479) tobymao

:broom: Chore
* Add custom pydantic types (1460) eakmanrq
* Update sqlglot to 18.7.0 tobymao
* Fix tests tobymao
* Update the Airflow end-to-end test izeigerman
* Cleanup github cicd bot tests (1470) eakmanrq
* Fix types (1478) tobymao

:alien: Other
* Add missing model config keys (1463) treysp

:beetle: Bug fixes
* Ensure overridden parser methods are called with the appropriate args (1459) GeorgeSittas
* Fix returning multiple values section in macro docs (1461) treysp

:broom: Chore
* Bump sqlglot to 18.6.0 (1462) izeigerman

:beetle: Bug fixes
* **(mssql)** Enable core functionality (1435) treysp
* Fix config ref connection titles (1455) treysp
* Properly validate scd type 2 fields (1456) eakmanrq

:broom: Chore
* Add materialized view test (1453) eakmanrq

:beetle: Bug fixes
* Allow fixtures to have fewer columns than model defs (1447) tobymao
* Sushi marketing udated_at dates were becoming mixed types tobymao
* Do not hydrate snapshots with intervals when deleting expired snapshots (1454) izeigerman

:beetle: Bug fixes
* Interval unit validation when loading the model definition from cache (1445) izeigerman
* **(snowflake)** Private_key should be bytes, update docs (1444) tobymao
* Partition a temporary table when insert-overwriting by partition in BQ (1449) izeigerman
* Add an alias to a subquery of ordered projections (1450) izeigerman

:sparkles: Features
* Support plan applications with MWAA (1429) izeigerman
* Add support for csv_settings in SeedModel kind (1442) GeorgeSittas
* Support CSV parser settings for seed models (1443) izeigerman

:beetle: Bug fixes
* Clear context audit dicts before reloading audits (1427) crericha
* Allow udt DataType.building for dialects that support UDTs (1438) GeorgeSittas
* Connection config parsing on the Airflow side (1439) izeigerman
* Omit materialized view schema for engines that don't support it (1440) GeorgeSittas
* Correctly drop materialized views (1441) izeigerman
* Create schemas sequentially when evaluating or promoting snapshots (1433) izeigerman

:broom: Chore
* Update documentation for MWAA support to reflect recent changes (1431) izeigerman
* Wrap JSON strings with PARSE_JSON() in values (1430) vchan

:alien: Other
* Format bullets and wordsmith (1426) treysp
* Document python-based SQL models (1423) GeorgeSittas
* Expand metrics docs (1428) treysp
* Clarify named gateway keys in configuration reference (1432) treysp
* Add model configuration reference page (1401) treysp
* Fix typo (1437) GeorgeSittas