Sqlmesh

:sparkles: Features
* Introduce the table diff API endpoint (955) vchan

:beetle: Bug fixes
* Determine model dependencies after rendering. (972) crericha
* Path to the duckdb database file in the sushi example project izeigerman
* Fix table diff cli tobymao
* Make loading faster (974) tobymao
* Return None if renderered jinja is only whitespace (976) crericha
* Support dbt_utils.star except argument (973) crericha
* Backfilling batch size for seeds should always be None (979) izeigerman
* Various bugs (969) mykalmax
* Avoid duplicate subscription on component reuse (981) mykalmax

:broom: Chore
* Updated packages (978) mykalmax

:alien: Other
* Update quickstart (970) treysp
* Only run UI tests when UI files have changed. (980) vchan

:sparkles: Features
* Add spark connection config (945) eakmanrq
* Add support for materialzied views (951) izeigerman
* Introduce support for pre- and post- statements to seeds (956) izeigerman
* Extend SQL parser with designated blocks for jinja code (963) izeigerman

:beetle: Bug fixes
* Update join macro logic to match latest sqlglot changes (950) GeorgeSittas
* Use the '--version' argument instead of the 'version' command for printing the version in CLI (954) izeigerman
* Support sql_header config and config.set() jinja method for dbt projects. (952) crericha
* When evaluating a snapshot render pre- and post-statements right before their evaluation (961) izeigerman
* Support config() method in jinja. (962) crericha
* Unit test due to merging the stale branch izeigerman
* Redundant extraction of macro references in jinja expressions (965) izeigerman
* Invalidate the in-memory cache for the columns-to-types mapping when updating the model's schema (971) izeigerman

:broom: Chore
* Updated dbt comparison documentation to include new SQLMesh features. (946) crericha
* **(docs)** Fix typo in engine docs (958) GeorgeSittas
* Increate the no_output_timeout to 15m for the Airflow integration tests izeigerman
* Cosmetic fix izeigerman
* Bump sqlglot version (968) GeorgeSittas

:alien: Other
* Update airflow.md (947) serkef
* Use fixed dates for table diff test (949) vchan
* Add section for materialized views izeigerman
* Update engines.md (957) serkef
* Clarify Bigquery connection methods (959) eakmanrq
* Update redshift connection id to be consistent (960) eakmanrq
* Use dialect when creating table (966) eakmanrq
* Bump sqlglot (967) eakmanrq

:sparkles: Features
* Add primary key capture to model to seed future interfaces (933) z3z1ma
* Add Restatement Support for depends_on_past (Built-in only) (921) eakmanrq

:beetle: Bug fixes
* Error if no columns found for table. (932) crericha
* Fix code highlighting in the models/overview.md doc izeigerman
* Use dbt source_name for source method and add support package arg for ref method. (935) crericha
* Ensure AST is correct in meta field converter (938) GeorgeSittas
* Normalize identifiers and model names (930) GeorgeSittas
* Small improvements to the doc page for external models izeigerman
* Select * from external models for dbt, skip private variables when deep copying JinjaMacroRegistry, and properly parse jinja pre and post expressions (943) crericha

:broom: Chore
* Output rendered queries to debug log. (931) crericha
* Fix typo and rephrase unresolved projections error. (936) crericha
* Fix table diff uni tobymao

:alien: Other
* Python macro functions (928) treysp
* Make rows key optional in test YAML (937) vchan
* Remove rows from sushi example project tests (939) vchan
* Add airflow depends_on_past (940) eakmanrq

:sparkles: Features
* Use pre / post SQL statements instead of hooks (910) izeigerman
* Add depends_on_past through self-reference check support (Built-in only) (917) eakmanrq
* Display node for CTE (915) mykalmax
* Table-diff, easily diff two tables. (907) tobymao

:beetle: Bug fixes
* Fix SQLMesh macro doc list rendering (924) treysp
* Fix macro docs sub-list formatting (925) treysp
* Ensure dict lookup won't fail during validation (922) GeorgeSittas
* Wrap router in suspense (918) mykalmax
* Some minor styling bugs (927) mykalmax
* Make sure internal models are not accidentally converted to external ones (926) izeigerman

:broom: Chore
* Chore[docs]: Restructure macro docs (905) treysp
* Add external models to sushi project (898) tobymao

:alien: Other
* Update links to macro docs (923) treysp
* Update setup.py (929) jecolvin

:alien: Other
* Include a model's CTEs when testing one of its CTEs (920) vchan

:sparkles: Features
* Display error tag on top level (854) mykalmax

:beetle: Bug fixes
* Evaluate snapshots after pomoting the environment if the plan contains paused forward-only snapshots (912) izeigerman
* Update sys_path before loading models. (914) crericha
* Use dialect in column_to_types_ validator (913) GeorgeSittas
* Re-fetch model's lineage after change to models/columns in file (891) mykalmax