Sqlmesh

:beetle: Bug fixes
* Remove import that forces pyspark tobymao

:beetle: Bug fixes
* Set catalog properly across connection and engine (2428) eakmanrq

:broom: Chore
* Update macro docs (2401) georgesittas

:sparkles: Features
* Add flag for preserving unit test fixtures to improve debuggability (2404) georgesittas
* Support variables in native SQLMesh projects (2391) izeigerman
* Improve lineage perf (2316) tobymao
* Support restatements for the incremental unmanaged model kind (2423) izeigerman

:beetle: Bug fixes
* Randomize unit test fixture names to avoid concurrency issues (2403) georgesittas
* Make a 1-1 correspondence between created/dropped fixtures in unit tests (2407) georgesittas
* The message used for prompting the backfill end date in CLI (2408) izeigerman
* Make partial setting in unit tests deterministic (2410) georgesittas
* Widen spark support (2409) eakmanrq
* Make Snowflake table part parsing more lenient (2412) georgesittas
* Avoid forcing quoted identifiers when creating views in trino and spark (2415) izeigerman
* Improve csv seed file type inference (2418) georgesittas
* Get physical table name in ibis example (2417) andrew-sha
* Ensure lineage doesn't mutate the model's query tobymao
* Use end-bounded missing intervals when checking for gaps during the promotion (2424) izeigerman

:hammer_and_wrench: Refactor
* Only use the last comment attached to a projection as its description (2421) georgesittas

:broom: Chore
* Use default_dialect property instead of config.dialect in context (2405) georgesittas
* Update databricks doc to link to notebook magic (2402) eakmanrq
* Only print the environment name in logs during the environment finalization izeigerman
* Chore! bump sqlglot to v23.8.0 (2411) georgesittas
* Fix typo in plans.md (2422) VaggelisD
* Add error message for untyped self references (2419) tobymao
* Document expected column order in unit tests (2427) georgesittas

:alien: Other
* Update mssql test from bytes to timestamp return value (2406) treysp
* Wordsmith comment registration docs (2416) treysp
* Clarify allowed cron values (2425) treysp
* Update duckdb incremental by unique key materialization strategy (2426) treysp

:beetle: Bug fixes
* Don't insert an empty dataframe of seed rows during migration izeigerman
* Set the default value for the _dbt_max_partition variable (2395) izeigerman
* Correctly return missing intervals when the model start / end is set (2397) izeigerman
* Allow macros to recursively resolve closes 2399 (2400) tobymao
* An individual plan DAG failure shouldn't prevent the remaining DAGs from loading in Airflow izeigerman

:hammer_and_wrench: Refactor
* Get rid of JSON escaping logic throughout the codebase (2386) georgesittas

:broom: Chore
* Bump sqlglot to v23.7.0 (2394) georgesittas

:alien: Other
* Trigger renovate last (2393) andrew-sha
* Add table migration guide (2385) treysp

:beetle: Bug fixes
* Don't insert an empty dataframe of seed rows during migration izeigerman

:sparkles: Features
* Add support for freezing time in unit tests (2362) georgesittas

:beetle: Bug fixes
* Don't warn about state (2371) eakmanrq
* Expand snowflake VIEW column comments and make comment default true (2369) treysp
* Top nav flashing (2326) mykalmax
* Some keyboard bindings (2334) mykalmax
* Send file updates for plan and lineage modules (2375) mykalmax
* Data hash values for the model kind (2376) izeigerman
* Handle maps during test generation (2364) vchan
* Only insert new seed rows during migration (2381) izeigerman
* Improve inference of upstream dependencies for python models (2377) izeigerman
* Normalize both lists and ndarrays when generating unit tests (2388) georgesittas
* Detection of broken model references when building a plan (2390) izeigerman

:broom: Chore
* Improve recommended state sync documentation (2367) eakmanrq
* Report success at the end of the run command (2374) izeigerman
* Make dbt scd type 2 test cicd only (2378) eakmanrq
* Bump sqlglot to v23.6.3 (2382) georgesittas
* Add a comment and an assert to test_broken_references to prevent future regressions izeigerman

:alien: Other
* Trigger renovate (2379) andrew-sha
* Revert "Chore!: bump sqlglot to v23.6.3 (2382)" (2387) georgesittas
* Update README.md (make email link a mailto) (2389) anentropic