Sqlmesh

:sparkles: Features
* Make all incremental models in a dbt project forward-only by default (1303) izeigerman
* Add model to promote (1292) eakmanrq

:beetle: Bug fixes
* Make file watcher ignore local db updates (1306) mykalmax
* Correctly check schema names when cleaning up (1304) eakmanrq
* Respect plan `include-unmodified` flag when no model changes (1296) treysp
* Display column description + display model references in docs (1305) mykalmax
* Remove debounce async (1308) mykalmax
* CLI table-diff styling (1313) treysp
* Table properties serde (1310) eakmanrq
* Styling updates for table and table-diff (1312) mykalmax
* Dbt-redshift 1.6 removed column class specialization (1320) crericha
* Format model on save (1309) mykalmax
* Use full file path to get model from path_to_model_mapping (1321) mykalmax
* Support latest Pydantic V2 version in tests (1325) izeigerman
* Fetch column types if the type is unknown for a partition column in the BQ engine adapter (1326) izeigerman

:broom: Chore
* Add the Delegating State Sync base class to simplify downstream implementations (1316) izeigerman

:alien: Other
* Update dbt docs with full list of unsupported jinja methods (1299) GeorgeSittas
* Add config link to state info question (1302) treysp
* Clean up audit in snapshot evaluator (1301) vchan
* Update table diff guide (1319) treysp
* Update configuration reference (1307) treysp

:sparkles: Features
* Add sqlmesh references and automatic joins (1278) tobymao
* Add ability to select node and build path from that node to current (1245) mykalmax
* Support Table Properties on Views (1286) eakmanrq
* Allow macro lambdas with expansion on tuples (1298) tobymao

:beetle: Bug fixes
* Improve interval_unit validation and support the field in dbt projects (1281) crericha
* Make Databricks use replace where (1291) eakmanrq
* Migration of grain tobymao
* Editor content updates too late with debounce mykalmax
* Set debounceImmediate to false for model lineage (1293) mykalmax
* Exclude redundant keys from the config attribute in dbt models (1294) izeigerman
* Support physical table schema override for dbt projects (1297) izeigerman

:broom: Chore
* Support Pydantic 2 (1290) izeigerman

:alien: Other
* Update engine integration docs (1288) treysp
* Strip trailing whitespace from docs (1289) treysp

:sparkles: Features
* Add column statistics to output and make sample opt in on cli (1265) z3z1ma
* Recreate a view if missing even if the rendered query hasn't changed (1268) izeigerman
* Table diff sample by row source (1272) treysp

:beetle: Bug fixes
* **(snowflake)** Extract date from datetime values, quote audit's this_model (1269) GeorgeSittas
* **(metrics)** Don't normalize metric names (1270) GeorgeSittas
* Remove debounce from initial request (1275) mykalmax
* Fix column stats display when no common columns (1279) treysp
* Resubscribe after new connection has beed established (1282) mykalmax
* Correctly recreate views for snapshots categorized as indirect non-breaking (1285) izeigerman

:broom: Chore
* Bump sqlglot to v17.10.2 (1276) GeorgeSittas

:alien: Other
* Add scheduling questions to FAQ (1267) treysp
* Add repo and social links mkdocs.yml (1271) SoumayaMauthoorMOJ
* Update table diff guide (1280) treysp
* Set immediate true for updating editor content (1283) mykalmax

:sparkles: Features
* Make default target environment configurable (1262) izeigerman
* Add ability to override the dbt target name in the SQLMesh config (1263) izeigerman
* Include Jinja macros when rendering a model definition (1264) izeigerman

:beetle: Bug fixes
* Rendering of a model definition with table properties specified (1261) izeigerman
* Fix!(tests): normalize identifiers according to the config's dialect (1206) GeorgeSittas
* Increase request timeout delay (1266) mykalmax
* Include catalog name in schema creation (1249) eakmanrq

:broom: Chore
* Add default_target_environment description to the configuration reference doc izeigerman

:alien: Other
* DRY up audit error messages and add model to audit result (1260) vchan

:beetle: Bug fixes
* Support inserting dataframes into Environment on Databricks (1242) eakmanrq
* Loading Python config while having Personal YAML file (1247) eakmanrq
* **(macros)** Incrementally resolve macro var definitions (1253) GeorgeSittas
* Timeout request after 10s by default (1225) mykalmax
* Implement richless Databricks console for Model Creation (1250) eakmanrq
* Pass sleep generator parameters directly into the Retry instance in the BigQuery adapter (1257) izeigerman

:broom: Chore
* Bump sqlglot to v17.9.0 (1248) GeorgeSittas
* Warn by default if the error occurs during the schema creation (1256) izeigerman

:alien: Other
* Raise errors if run dag fails (1251) eakmanrq
* Remove console for errors and push all errors to top level (1255) mykalmax

:sparkles: Features
* MySQL support (1232) izeigerman
* Sync file system via sse (1197) mykalmax
* Make Environment Suffix Target Configurable (1220) eakmanrq

:beetle: Bug fixes
* Correctly set the hive dynamic partition mode (1229) pingzh
* Styling bugs around lineage (1223) mykalmax
* Wrong key for tabs triggers re-renders (1233) mykalmax
* Use a pendulum datetime object for the start_date attribute in Airflow (1230) izeigerman
* Wrong argument order for getCellContent (1234) mykalmax
* Spark partition by on state tables (1238) eakmanrq
* Fix progress when completed (1239) eakmanrq
* Improve Databricks Catalog setting (1240) eakmanrq
* Set the plan DAG start date at request time (1244) izeigerman

:broom: Chore
* Improve the error message in the query renderer (1231) izeigerman

:alien: Other
* Document state schema feature (1236) eakmanrq
* Update plans concept page (1235) treysp
* Expand FAQ (1226) treysp
* Include catalog in table name (1241) eakmanrq