Sqlmesh

:beetle: Bug fixes
* Remove overlapping intervals in old snapshots superseded by a new unpaused snapshot with the effective date set (788) izeigerman
* Normalize macro names tobymao
* Merge should use columns_to_types, so it can support pandas dfs (792) crericha
* DataFrame Where Clause Quoting (793) eakmanrq

:hammer_and_wrench: Refactor
* Print rendered dag location in terminal (789) cornzyblack

:broom: Chore
* Add redshift profile to dbt example project (791) crericha
* Bump sqlglot to v11.6.3 (795) GeorgeSittas

:alien: Other
* Escape redshift (787) eakmanrq
* Improve documentation around the `batch_size` property (794) plaflamme
* Add the if macro. (796) tobymao

:sparkles: Features
* Add ability to set the effective date for forward-only snapshots (785) izeigerman

:beetle: Bug fixes
* For forward-only plans run backfill after promotion (774) izeigerman
* Display nodes more condensed, update connection on column name change (781) mykalmax
* Support dbt model jinja method, use dialect when parsing, catch duplicate key errors, and improve parse time for very large sql models (782) crericha
* When applying a forward-only plan in dev the backfill shoulde precede the promotion (786) izeigerman
* Handle no rows in versions table due to corruption tobymao
* Flaky test with new sqlglot. tobymao

:broom: Chore
* Upgrade to sqlglot 11.6 and clean up example project paths tobymao

:alien: Other
* Reset selected lineage columns on tab change (772) mykalmax
* Add Dataframe Merge Support (770) eakmanrq
* Remove self from depends_on (773) eakmanrq
* Use jinja2 loopcontrols extension (776) crericha
* Remove catalog/db from spark temp view (777) eakmanrq
* What does backfill mean? (778) foundinblank
* Modify quickstart project and add seed file (779) foundinblank
* Add model tags field (775) vchan
* Redshift config port can be a string in profiles.yml (784) crericha

:beetle: Bug fixes
* Caching of rendered dbt model configs by making the dependencies attribute public (768) izeigerman
* Don't validate on migration (771) tobymao

:beetle: Bug fixes
* Always validate versions whenever a state sync is accessed (769) tobymao
* Multi repo test to use memory tobymao

:sparkles: Features
* Display tests report (729) mykalmax
* [dbt] Support incremental_by_unique_key when unique_key defined with no incremental_strategy (731) crericha
* Add execution config for BigQuery (732) eakmanrq
* Introduce the caching layer when loading SQL models (733) izeigerman
* Column-level lineage (663) mykalmax
* Lookback windows closes 728 (736) tobymao
* Add dialect to cli render closes 741 tobymao
* Add lookback to dbt projects (760) crericha
* Highlight know columns in editor (761) mykalmax

:beetle: Bug fixes
* Fix links (739) crericha
* Clarify in docs that type casting in a model's query is not mandatory (742) izeigerman
* Drop view in order to replace it when using Postgres (751) izeigerman
* Explicitly set the end and the latest dates in the Airflow end-to-end test izeigerman
* Enable logging in CLI when the debug mode is enabled izeigerman
* Clean-up target defaults (735) crericha
* Dbt hook yaml formats, duplicate yaml keys, and sources without tables (745) crericha
* Apply lookback window to the data interval start date when running a cadence DAG in Airflow (759) izeigerman
* Allow empty files in models folder and refetch lineage on model file change (746) mykalmax
* Selecting column in lineage (766) mykalmax
* Migrate table schemas only for snapshots with the FORWARD_ONLY category explicitly assigned (763) izeigerman
* Introduce environment finalization (764) izeigerman
* Airflow integration test by assigning a change category correctly izeigerman

:broom: Chore
* Add ability to enable a debug mode (743) izeigerman
* Add the 'info' command to CLI (744) izeigerman
* Move batch_size inside kind. BREAKING CHANGE. (749) tobymao
* Update vm2 version (747) mykalmax
* Delete project cache before using in a test (762) crericha

:alien: Other
* Updated notebook.md (734) ShanksData
* Fixed typo (738) AlessandroLollo
* Add bigquery storage dependency (756) eakmanrq
* Add Postgres to engine configuration list (755) jared-rimmer
* Remove pg keep_alives default (758) eakmanrq
* Update tests tobymao
* Update slack links tobymao
* Update slack link (767) vchan

:sparkles: Features
* Support nested add/remove columns + positional additions (655) eakmanrq
* File state adapter (711) z3z1ma
* Support dbt quoting config (715) crericha
* Support multiple repos (704) tobymao
* Add Postgres Support (built-in, Airflow, dbt) (677) eakmanrq
* Render should not quote identifiers by default (726) crericha

:beetle: Bug fixes
* Sqlglot wasn't replacing all lambda vars with identifiers tobymao
* Include hours and minutes when formatting missing intervals (722) izeigerman
* [dbt] materialized can be jinja and allow, but warn, on extra profile fields (721) crericha
* Run plan in default event loop instead of an executor (727) vchan

:broom: Chore
* Add UI test job to CI (712) vchan
* Multi-repo docs tobymao

:alien: Other
* Split test command for unit and e2e (710) mykalmax
* Update EditorPreview.tsx (713) mykalmax
* Cleanup transactional file implementation (716) tobymao
* Add the 'Virtual Environments for Data' blog post (714) izeigerman
* Edit the Virtual Data Environments post izeigerman
* Add stamp to docs tobymao
* [Fix] Small fix after integration testing on GCS (723) z3z1ma
* Cleanup tobymao
* Rename blog post file izeigerman
* Use virtual environment name (725) eakmanrq
* Update docs tobymao