Sqlmesh

: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

:beetle: Bug fixes
* Table creation for forward-only snapshots of newly added models izeigerman

:sparkles: Features
* Add SCD Type 2 Support (1350) eakmanrq

:beetle: Bug fixes
* Support snapshots of added models with forward-only parents (1372) izeigerman

:broom: Chore
* Remove print statements (1373) eakmanrq

:alien: Other
* Remove distinct (1371) eakmanrq
* Add extras to installation docs page (1370) treysp

:beetle: Bug fixes
* Improvements to Github CI/CD Bot Documentation (1367) eakmanrq
* Fallback to the breaking change category if the model's query can't be rendered at parse time and the auto categorization mode is set to FULL (1369) izeigerman

:broom: Chore
* Suggest a command to run when raising an error about the need for migration (1368) izeigerman

:sparkles: Features
* Show loading state when evaluating/getting def (1356) mykalmax
* Support forward-only models in regular plans (1355) izeigerman
* Use table clones instead of temp tables in dev environments for engines that support this (1364) izeigerman
* Send query on shift-enter + option to open file in new tab (1361) mykalmax

:beetle: Bug fixes
* Remove nodes and edges from shared state (1333) mykalmax
* Update react-virtual and apply new API to table (1337) mykalmax
* Preserve show options + display column count + increase timeout delay… (1332) mykalmax
* Mssql if exists (1349) tobymao
* Remove option to provide limit when running sql (limit should be part of sql) (1357) mykalmax
* Apply virtualization to rows (1354) mykalmax
* **(bigquery)** Sanitize physical table name closes 1352 (1358) tobymao
* **(bigquery)** Fixes issue when dropping bigquery names with projects (1359) tobymao

:broom: Chore
* Cleanup docs tobymao
* Revert an unnecessary make_snapshot change izeigerman
* Updated packages (1363) mykalmax

:alien: Other
* Add info about MWAA support (1342) treysp
* Add config concepts page with python config info (1346) treysp
* Pin pandas version (1365) vchan