Sqlmesh

: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

:beetle: Bug fixes
* Connection config parsing on the Airflow side (1439) izeigerman

:beetle: Bug fixes
* Missing upstream snapshot in the v0023 migration script (1425) izeigerman

:beetle: Bug fixes
* Add spinner and cancel to file actions (run query, evaluate, diff) (1421) mykalmax
* Set file extension for created file based on parent (1420) mykalmax
* Prevent duplicate file name in same folder (1419) mykalmax
* Create new snapshots instead of overwriting the existing ones during migration (1414) izeigerman
* Order query projections to match the target table's schema (1424) izeigerman

:sparkles: Features
* Spark schema to sqlglot support (1411) eakmanrq
* Add merge support to Redshift (1412) eakmanrq
* Automatic dim joins (1403) tobymao
* Add standalone audits to sqlmesh format (1396) crericha
* Add support for pre/post statements in python models (1413) GeorgeSittas
* Add rewriter to context, cli, and notebook (1417) tobymao

:beetle: Bug fixes
* Update airflow operators to work with standalone audits (1416) crericha
* Use model's columns_to_types if available in tests (1415) vchan

:broom: Chore
* Add Automated Engine Adapter Integration Tests (1418) eakmanrq
* Bump sqlglot to v18.5.0 (1422) GeorgeSittas

:sparkles: Features
* Add pinned_environments/default_target_environment + ability to delete env (1360) mykalmax
* Add model name to audit log (1376) datnguye

:beetle: Bug fixes
* Clear timeoutId and callback to avoid zombie timeouts (1375) mykalmax
* Table creation for forward-only snapshots of newly added models izeigerman
* Fix defaul model kind list, add defaults config examples (1374) treysp
* Do not throw on canceled request (1377) mykalmax
* Make interval unit a part of the data hash (1386) izeigerman
* Handle exp.Array when validating unique_key (1388) GeorgeSittas
* Automatic derivation of a partitioning transformation for a time column in BigQuery (1389) izeigerman
* Fix formatting (1394) eakmanrq
* Ensure external macros are resolved correctly (1392) GeorgeSittas
* Num audits detected by sqlmesh audit was incorrect (1400) crericha
* Improve error reporting when validating the connection config (1404) izeigerman
* Use PARTITIONS view to fetch table partitions in the BigQuery adapter (1406) izeigerman
* Sanitized model names before using them as part of Airflow task IDs (1407) izeigerman
* Snapshot table should contain the kind_name enum value, not the enum (1410) crericha
* Add check for key (1408) z3z1ma

:broom: Chore
* Improve Engine Adapter Abstraction for Handling DataFrames (1362) eakmanrq

:alien: Other
* Support dbt singular tests (1348) crericha
* Note macro column name interpolation limitation (1378) treysp
* Chore: bump sqlglot, fix mssql tests and a couple of type hints (1384) GeorgeSittas
* Extend documentation with recent changes to forward-only models (1385) izeigerman
* Clarify need to save model file to see updated lineage (1387) treysp
* Clarify incremental by time model automatic filter (1382) treysp
* Add environment variables to config guide (1393) treysp
* Detect merge conflict (1399) eakmanrq
* Add snowflake private key support (1409) eakmanrq
* Update cli reference plan args (1398) treysp