Sqlmesh

:sparkles: Features
* Databricks allow disabling spark session (2703) eakmanrq

:beetle: Bug fixes
* Avoid using concat_ws when there's only one key is present (2711) izeigerman

:broom: Chore
* Allow to skip connection testing in the 'info' command (2705) izeigerman
* Bump sqlglot to v24.1.0 (2708) georgesittas
* Include the user agent information as part of the MotherDuck connection config (2706) izeigerman

:alien: Other
* Update info magic help string (2707) treysp

:beetle: Bug fixes
* **(motherduck)** Filter on catalog name in DuckDB _get_data_objects query (2699) treysp
* Exclude private key from the state sync fingerprint calculation (2704) izeigerman

:broom: Chore
* Fix typo tobymao

:alien: Other
* Add UI guide (2700) treysp

:broom: Chore
* Ping sqlglot to 24.0.2 izeigerman

:sparkles: Features
* Snowpark (2666) tobymao
* Introduce INCREMENTAL_BY_PARTITION model kind (2687) izeigerman

:beetle: Bug fixes
* Allow partial query results in unit tests, update docs (2676) georgesittas
* Add missing reporting for builtin runs (2675) izeigerman
* For MSSQL apply the same workaround for the varchar size as we use for Redshift (2674) izeigerman
* Correct destructive change error messages (2678) treysp
* Use exp.column when casting seed columns to avoid ParseError (2686) georgesittas
* Unescape sequences in CSV settings (2690) georgesittas
* Remove remaining dynamic overwrite modes (2692) eakmanrq
* Ensure MacroEvaluator.columns_to_types returns types as DataTypes (2694) georgesittas

:broom: Chore
* Add google analytics to docs (2682) treysp
* Update unit test docs to include specifying query as fallback (2683) georgesittas
* Update docs for ui formatter option (2685) simonprydden
* Allow usage of start_* / end_* macros in SCD2 models (2691) izeigerman
* Don't store the seed's content in the state (2688) izeigerman
* Fix airflow tests izeigerman

:alien: Other
* Add csv_settings to seed models concepts doc (2679) treysp
* Clarify incremental by unique key in kinds concepts doc (2680) treysp
* Add docs for incremental by partition model kind (2695) treysp

:sparkles: Features
* Extend CSV support with settings; update test docs (2663) Themiscodes

:beetle: Bug fixes
* Propagate normalized snapshot name to differ (2673) z3z1ma

:broom: Chore
* Set the lower bound for the dbt-sqlserver dependency (2670) izeigerman
* Use ping to validate connections (2652) eakmanrq

:sparkles: Features
* Improve the CLI output of the table diff command (2644) izeigerman
* Forward-only changes schema modification check (2576) treysp
* Add support for CSV input data loading from file or inline (2640) Themiscodes
* Enable duckdb>=0.10 comment registration (2660) treysp

:beetle: Bug fixes
* Fix pytest warning on test fixture (2648) erindru
* Stop column description propagation if model cannot be found. (2649) vchan
* Correctly handle dependency in the migration test (2651) izeigerman
* Fix test runner not displaying dots for successes (2656) (2657) giovannipcarvalho
* Delete intervals in batches during compaction (2658) izeigerman

:broom: Chore
* Bump sqlglot to v24.0.0 (2647) treysp
* Include local sqlmesh configs in integration test context (2650) treysp
* Exclude the 0.10.3 duckdb release (2659) izeigerman