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

v0.10.0

🪲 Bug fixes

• Fix State Sync CTAS Replace (#861) @eakmanrq
• Hydrate the seed model if needed in the built-in scheduler (#859) @izeigerman
• Make sure that seed column hashes are updated during the migration (#863) @izeigerman
• Duplicates on migrations (#862) @tobymao

v0.9.0

✨ 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

🪲 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

🛠️ Refactor

• Use sqlglot's exp.insert to simplify Insert building (#855) @georgesittas

🧹 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

👽 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

v0.8.1

✨ Features

• Docs lineage for change categories (#817) @mykalmax

🪲 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

👽 Other

• Always redirect back to index.html (#836) @mykalmax