v0.13.0

✨ 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

🪲 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

🧹 Chore

• Chore[docs]: Restructure macro docs (#905) @treysp
• Add external models to sushi project (#898) @tobymao

👽 Other

• Update links to macro docs (#923) @treysp
• Update setup.py (#929) @jecolvin

v0.12.4

👽 Other

• Include a model's CTEs when testing one of its CTEs (#920) @vchan

v0.12.3

✨ Features

• Display error tag on top level (#854) @mykalmax

🪲 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

v0.12.2

🪲 Bug fixes

• Escape double quotes for strings in dbt test kwargs. (#900) @crericha
• Support columns for late-binding views in Redshift. (#906) @crericha

🧹 Chore

• Fix mypy type hints, function prototypes to get parity with sqlglot (#901) @georgesittas
• Fix mypy issues, use _parse_table_parts instead of _parse_table (#903) @georgesittas
• Small cleanup of dialect.py (#909) @georgesittas

v0.12.1

🪲 Bug fixes

• External models hash and is_breaking (#897) @tobymao

v0.12.0

✨ Features

• Store snapshot intervals separately from snapshot payloads (#865) @izeigerman
• Convert dbt tests into SQLMesh audits (#858) @crericha
• Add Github Action Bot Deploy Command (#868) @eakmanrq
• Add Databricks Connect Support (#860) @eakmanrq

🪲 Bug fixes

• Fix databricks freezing (#875) @eakmanrq
• Fix typos (#878) @treysp
• Docs semi colon @tobymao
• Pint airflow-providers dependencies @izeigerman
• Pin apache-airflow-providers-common-sql in the Airflow docker image @izeigerman
• Render model / audit query when computing a snapshot fingerprint when using the native SQLMesh format (#879) @izeigerman
• Quote 0007 migration query because snapshot is a reserved word in Redshift. (#886) @crericha
• Allow create_external_models to run for projects with star projections and support dbt formatted projects. (#880) @crericha
• Derive the name of a snapshot's physical schema from its model's schema (#885) @izeigerman
• Skip model loading for migrate and rollback commands. (#888) @crericha
• Use the models' dialects in schema methods (#889) @georgesittas
• Fix state sync rollback test case (#894) @vchan
• Alias queries even if not optimized (#895) @tobymao
• Concat Dataframes if insert overwrite (#890) @eakmanrq
• Use SUPPORTS_INSERT_OVERWRITE and cleanup (#893) @eakmanrq

🛠️ Refactor

• Refactor tests and introduce Python model tests (#874) @vchan

🧹 Chore

• Change dbt project status logging from info to debug (#881) @crericha
• Update error message and method docs (#887) @crericha
• Bump sqlglot to v14.0.0 (#896) @georgesittas

👽 Other

• Don't use bugged typing-extensions release (#882) @eakmanrq
• Use latest pyspark (#883) @eakmanrq
• Expand macro documentation (#877) @treysp

v0.11.2

🪲 Bug fixes

• Make sure we never use actual physical names of external tables when evaluating snapshots @izeigerman
• Quickstart example, csv strip spaces closes #876 @tobymao

🧹 Chore

• Update packages (#866) @mykalmax

v0.11.1

🪲 Bug fixes

• Add external models to the index @tobymao

v0.11.0

✨ Features

• Add external models and loader to improve optimizer. (#871) @tobymao
• Add docs for external models (#873) @tobymao

🪲 Bug fixes

• Not propogating external kind @tobymao
• Ensure external is not expanded @tobymao
• Don't drop views of external sources. @tobymao
• Call on_complete handler when promoting / demoting external models @izeigerman

🧹 Chore

• Use enum value @tobymao
• Add test for rendering on external @tobymao
• Update sqlglot @tobymao

👽 Other

• Ignore local config when running tests (#872) @eakmanrq

v0.10.1

🪲 Bug fixes

• Make sure start_at / end_at are strings when storing an environment record in state sync (#870) @izeigerman