Sqlmesh

: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

:sparkles: Features
* Support custom schema name for state metadata (1171) eakmanrq
* CI/CD Bot Add Merge Method (1207) eakmanrq
* Respect the model's cron expression in the built-in scheduler (1209) izeigerman
* Make interval unit configurable per model (1213) izeigerman
* Add physical schema override (1212) eakmanrq
* Allow specifying of arbitrary table properties as part of the model definition (1217) izeigerman
* Initial pass of SQLMetrics (1221) tobymao

:beetle: Bug fixes
* Use VARCHAR instead of TEXT for MySQL pks, indexed fields (1208) GeorgeSittas
* Increase timeout-keep-alive and send ping every 15s to browser (1172) mykalmax
* Send cancel plan request when canceling plan (1210) mykalmax
* Remove latest time in favour of execution time (1211) izeigerman
* Allow render output to wrap instead of cropping (1222) z3z1ma
* Parsing of the quoting config (1227) izeigerman
* Enable Hive dynamic partition in Spark session (1228) izeigerman

:hammer_and_wrench: Refactor
* Serialize the source SQL code for each expression (1187) GeorgeSittas

:broom: Chore
* Cleanup tobymao
* Improve the warning message when missing a schema while optimizing a model query (1224) izeigerman

:alien: Other
* Always get merge commit regardless event type (1203) eakmanrq
* Add FAQ (1214) treysp
* Correct select * and model default kind (1216) treysp