Sqlmesh

:sparkles: Features
* Allow using $root in seed paths to specify path relative to context path (1976) z3z1ma
* Send sse on file formatting (1968) mykalmax
* Add snowflake oauth access token support (1977) mkilpat
* Only promote selected models in dev when selector is used (1991) izeigerman
* Add default_catalog to the macro environment (1988) z3z1ma

:beetle: Bug fixes
* Set default value for category change (1967) mykalmax
* Propagate the dialect into Python models (1970) izeigerman
* Missing node type for removed snapshots in context diff (1969) vchan
* Send sse error if file watcher throws (1947) mykalmax
* Normalize catalog name in env catalog mapping (1973) eakmanrq
* Share connection config state sync instead of adapters (1975) eakmanrq
* Config fingerprint is not deterministic resulting in cache misses when... (1946) z3z1ma
* Correct the inclusive arg audits and docs (1981) z3z1ma
* Normalize max end interval by snapshot when models are selected explicitly (1980) izeigerman
* Prefer the builtin is_incremental macro over the dbt one (1989) izeigerman

:broom: Chore
* Add a unit test for the plan's [un]categorized properties (1964) izeigerman
* Add quotes to arguments (1971) eakmanrq
* Drop Python 3.7 support (1965) izeigerman
* Pin PySpark version izeigerman
* Remove FIXME for the pydantic test izeigerman
* Report the progress of the janitor process (1983) izeigerman
* Document the 'gateway' macro (1986) izeigerman
* Bump sqlglot to v20.9.0 (1984) georgesittas

:alien: Other
* Update README.md (1966) csreuter
* Use name and not displayName for when adding to selected edges (1972) mykalmax

:sparkles: Features
* Add limited dbt snapshot support (1960) eakmanrq
* Change arrow direction and add model selector to dag (1961) tobymao

:beetle: Bug fixes
* Ignore external models during cleanup (1957) eakmanrq
* Improve lineage load time (1935) mykalmax
* Remove categorized and uncategorized plan cache (1963) eakmanrq

:alien: Other
* Add python example of duckdb catalog configuration (1958) treysp
* Add quickstart video to landing page (1959) treysp
* Include elk worker in output bundle (1962) mykalmax

:beetle: Bug fixes
* Catalog migration bigquery (1955) eakmanrq
* Ensure deps are not functions closes 1945 (1953) tobymao

:broom: Chore
* Remove dead code in Airflow-related modules (1950) izeigerman
* Don't parallelize tests by default (1952) eakmanrq

:sparkles: Features
* Context support pathlib.Path paths (1942) eakmanrq

:beetle: Bug fixes
* Only drop a materialized view if it's supported by the target engine (1943) izeigerman
* Show only user macro count in info (1948) eakmanrq
* Pass dialect to name field value converter (1949) z3z1ma

:broom: Chore
* Parallelize tests by module (1939) eakmanrq
* Parallelize by test (1944) eakmanrq
* Update development documentation (1951) eakmanrq

:sparkles: Features
* Upgrade sqlglot and unquote mapping schema (1929) tobymao
* Update magics to match cli functionality (1919) eakmanrq
* Use max interval end of selected models when picking a default plan end (1931) izeigerman
* Add model caching for snapshots (1930) tobymao

:beetle: Bug fixes
* Fix code highlighting in model kinds concepts docs (1928) treysp
* Default value for the max snapshot IDs per request used for Cloud Composer (1932) izeigerman
* Revert to the old plan end behavior (1936) izeigerman
* Improve interval cache further (1934) tobymao
* Prefer existing snapshots when mapping snapshot records during migration (1940) izeigerman

:broom: Chore
* Refactor Plan definition into immutable Plan and mutable PlanBuilder (1925) izeigerman
* Reorganize test marks (1933) eakmanrq
* Fix engine integration test (1937) eakmanrq
* Bump sqlglot to 20.8.0 (1938) crericha

:beetle: Bug fixes
* In Airflow delete orphaned snapshot DAGs when new versions supersede the old ones (1918) izeigerman
* Only push new records when migrating snapshot rows (1927) izeigerman

:broom: Chore
* Clarify migration instructions (1921) eakmanrq
* Bump sqlglot to v20.6.0 (1926) georgesittas