Sqlmesh

:sparkles: Features
* Allow sqlmesh models to import jinja macros. (837) tobymao
* Cache snapshot start to improve load time of large projects (826) crericha
* Introduce state backups during migrations (824) vchan
* Feat[breaking]: don't qualify columns on external tables. (840) tobymao
* Store seed content separately from snapshot payload (853) izeigerman
* Display external table in lineage (857) mykalmax

:beetle: Bug fixes
* Support manifest generated by dbt 1.2 (839) izeigerman
* Run only one workflow at a time in CircleCI izeigerman
* Use load API to insert append dataframes in the BigQuery adapter (841) izeigerman
* Use pd.DataFrame to insert snapshots and environments in state sync (843) izeigerman
* Use the public SQLGlot diff API when categorizing changes (845) izeigerman
* In Engine Adapter automatically infer columns-to-types from a DataFrame (844) izeigerman
* Remaining Engine Adapter API which require column schema when pandas DataFrame is passed (847) izeigerman
* Use explicit column-to-types mapping in the state sync izeigerman
* Python 3.7 mypy izeigerman
* Use Snowflake's API to write a dataframe into a table (850) izeigerman
* Escape JSON when inserting a dataframe (849) izeigerman
* Mypy error due to merging without rebasing first izeigerman
* Return no missing intervals for seed models if evaluated at least once (851) izeigerman
* Improve lineage performance (848) mykalmax
* Simplify validation izeigerman
* Improve performance of sushi example. tobymao
* In Snowflake adapter return the DataFrame as is without modifying its column names. (846) izeigerman
* Move circleci release pipeline back into the config.yaml izeigerman

:hammer_and_wrench: Refactor
* Use sqlglot's exp.insert to simplify Insert building (855) GeorgeSittas

:broom: Chore
* BREAKING remove unused getter apis for macros/hooks (838) tobymao
* Move the release workflow into the continue_config.yml izeigerman
* Fix CircleCI config izeigerman
* Improve error message tobymao

:alien: Other
* Add Tests to Github Action CI/CD Bot (852) eakmanrq
* Update dbt incremental docs (790) treysp
* Handle external tables when fetching lineage (856) vchan

:sparkles: Features
* Docs lineage for change categories (817) mykalmax

:beetle: Bug fixes
* Include source dependencies in depends_on for dbt models. (827) crericha
* Fix json encoding for models (828) vchan
* Pin dbt-duckdb version to avoid test failures izeigerman
* Replace exp.StructKwarg with exp.ColumnDef in schema diff (830) GeorgeSittas
* Improve the change categorization results by pre-matching root AST nodes (831) izeigerman
* Various bugs from file tree, editor, lineage, docs (832) mykalmax
* Improve performance of get snapshots queries by using IN instead of AND/OR (820) crericha

:alien: Other
* Always redirect back to index.html (836) mykalmax

:sparkles: Features
* Add loading logging to dbt adapter (804) crericha
* Gateway configuration BREAKING CHANGE (807) izeigerman
* Extend Airflow integration with the ability to provide an external DB connection for SQLMesh state (811) izeigerman
* Introduce logical merge for adapters that do not natively support merge (802) crericha
* BREAKING always parse macro returns as sql (815) tobymao
* Add Github Actions CI/CD Bot (810) eakmanrq
* Set up Docs (801) mykalmax
* Log exception stack traces from executor tasks to API console (825) vchan
* Use dbt manifest to load dbt projects (821) izeigerman

:beetle: Bug fixes
* In Postgres engine adapter only commit if there's no active transaction (800) izeigerman
* Pin ruamel.yaml version when running airflow tests on CircleCI izeigerman
* Data leakage was incorrect with window functions BREAKING CHANGE (805) tobymao
* Enforce unpaused parent snapshots only for new snapshots (809) izeigerman
* Don't add where false if no from statement tobymao
* Use package materialization config in dbt fixture (816) crericha
* Cnclude missing direct model names (822) mykalmax

:broom: Chore
* Upgrade sqlglot to 11.7 tobymao
* Upgrade sqlglot tobymao

:alien: Other
* Update uvicorn development server configs (806) vchan
* Continue watching even if context.load() fails, e.g. typos in a model file (808) vchan
* Format code (812) cornzyblack
* Update engines.md (813) wseaton
* Remove unneeded expand tobymao
* Improve BigQuery Pandas Implementation (814) eakmanrq
* Add missing import (823) eakmanrq

:sparkles: Features
* Introduce LLM integration (799) izeigerman

:beetle: Bug fixes
* Make start_date an actual date and add start_dt tobymao

: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