Sqlmesh

: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

:sparkles: Features
* Generate CTE fixtures too when using the create_test command (2353) georgesittas

:beetle: Bug fixes
* Don't load models if start is ahead of end (2368) eakmanrq

:broom: Chore
* Use constant for list of commands that skip loading models (2363) crericha
* Update CLI command reference (2365) georgesittas

:alien: Other
* Fix docs for dag CLI (2356) andrew-sha
* Add model DDL columns example (2366) treysp

:sparkles: Features
* Allow partial to be for every output in a test (2355) georgesittas
* A CLI command to print the name of the physical table for a model (2340) izeigerman
* Allow UNION macros as model queries (2361) georgesittas

:beetle: Bug fixes
* Handle nested arrays during test generation (2359) vchan
* fix checking missing intervals against model end dates (2358) eakmanrq

:alien: Other
* Only include commit subject in webhook (2360) andrew-sha

:beetle: Bug fixes
* In scd type 2 also make sure all columns are known (2349) eakmanrq
* Ensure start if using end (2347) eakmanrq
* Modify test webhook (2352) andrew-sha
* Fix typo in sqlmesh_macros.md (2354) damjad

:broom: Chore
* Cleanup dialect variable reuse (2350) eakmanrq
* Send build url in test webhook (2345) andrew-sha

:alien: Other
* Normalize array before timestamps during test creation (2351) vchan