v0.32.1

🪲 Bug fixes

• Interval unit validation when loading the model definition from cache (#1445) @izeigerman
• (snowflake) Private_key should be bytes, update docs (#1444) @tobymao
• Partition a temporary table when insert-overwriting by partition in BQ (#1449) @izeigerman
• Add an alias to a subquery of ordered projections (#1450) @izeigerman

v0.32.0

✨ Features

• Support plan applications with MWAA (#1429) @izeigerman
• Add support for csv_settings in SeedModel kind (#1442) @georgesittas
• Support CSV parser settings for seed models (#1443) @izeigerman

🪲 Bug fixes

• Clear context audit dicts before reloading audits (#1427) @crericha
• Allow udt DataType.building for dialects that support UDTs (#1438) @georgesittas
• Connection config parsing on the Airflow side (#1439) @izeigerman
• Omit materialized view schema for engines that don't support it (#1440) @georgesittas
• Correctly drop materialized views (#1441) @izeigerman
• Create schemas sequentially when evaluating or promoting snapshots (#1433) @izeigerman

🧹 Chore

• Update documentation for MWAA support to reflect recent changes (#1431) @izeigerman
• Wrap JSON strings with PARSE_JSON() in values (#1430) @vchan

👽 Other

• Format bullets and wordsmith (#1426) @treysp
• Document python-based SQL models (#1423) @georgesittas
• Expand metrics docs (#1428) @treysp
• Clarify named gateway keys in configuration reference (#1432) @treysp
• Add model configuration reference page (#1401) @treysp
• Fix typo (#1437) @georgesittas

v0.31.4

🪲 Bug fixes

• Connection config parsing on the Airflow side (#1439) @izeigerman

v0.31.3

🪲 Bug fixes

• Missing upstream snapshot in the v0023 migration script (#1425) @izeigerman

v0.31.2

🪲 Bug fixes

• Add spinner and cancel to file actions (run query, evaluate, diff) (#1421) @mykalmax
• Set file extension for created file based on parent (#1420) @mykalmax
• Prevent duplicate file name in same folder (#1419) @mykalmax
• Create new snapshots instead of overwriting the existing ones during migration (#1414) @izeigerman
• Order query projections to match the target table's schema (#1424) @izeigerman

v0.31.1

✨ Features

• Spark schema to sqlglot support (#1411) @eakmanrq
• Add merge support to Redshift (#1412) @eakmanrq
• Automatic dim joins (#1403) @tobymao
• Add standalone audits to sqlmesh format (#1396) @crericha
• Add support for pre/post statements in python models (#1413) @georgesittas
• Add rewriter to context, cli, and notebook (#1417) @tobymao

🪲 Bug fixes

• Update airflow operators to work with standalone audits (#1416) @crericha
• Use model's columns_to_types if available in tests (#1415) @vchan

🧹 Chore

• Add Automated Engine Adapter Integration Tests (#1418) @eakmanrq
• Bump sqlglot to v18.5.0 (#1422) @georgesittas

v0.31.0

✨ Features

• Add pinned_environments/default_target_environment + ability to delete env (#1360) @mykalmax
• Add model name to audit log (#1376) @datnguye

🪲 Bug fixes

• Clear timeoutId and callback to avoid zombie timeouts (#1375) @mykalmax
• Table creation for forward-only snapshots of newly added models @izeigerman
• Fix defaul model kind list, add defaults config examples (#1374) @treysp
• Do not throw on canceled request (#1377) @mykalmax
• Make interval unit a part of the data hash (#1386) @izeigerman
• Handle exp.Array when validating unique_key (#1388) @georgesittas
• Automatic derivation of a partitioning transformation for a time column in BigQuery (#1389) @izeigerman
• Fix formatting (#1394) @eakmanrq
• Ensure external macros are resolved correctly (#1392) @georgesittas
• Num audits detected by sqlmesh audit was incorrect (#1400) @crericha
• Improve error reporting when validating the connection config (#1404) @izeigerman
• Use PARTITIONS view to fetch table partitions in the BigQuery adapter (#1406) @izeigerman
• Sanitized model names before using them as part of Airflow task IDs (#1407) @izeigerman
• Snapshot table should contain the kind_name enum value, not the enum (#1410) @crericha
• Add check for key (#1408) @z3z1ma

🧹 Chore

• Improve Engine Adapter Abstraction for Handling DataFrames (#1362) @eakmanrq

👽 Other

• Support dbt singular tests (#1348) @crericha
• Note macro column name interpolation limitation (#1378) @treysp
• Chore: bump sqlglot, fix mssql tests and a couple of type hints (#1384) @georgesittas
• Extend documentation with recent changes to forward-only models (#1385) @izeigerman
• Clarify need to save model file to see updated lineage (#1387) @treysp
• Clarify incremental by time model automatic filter (#1382) @treysp
• Add environment variables to config guide (#1393) @treysp
• Detect merge conflict (#1399) @eakmanrq
• Add snowflake private key support (#1409) @eakmanrq
• Update cli reference plan args (#1398) @treysp

v0.30.1

🪲 Bug fixes

• Table creation for forward-only snapshots of newly added models @izeigerman

v0.30.0

✨ Features

• Add SCD Type 2 Support (#1350) @eakmanrq

🪲 Bug fixes

• Support snapshots of added models with forward-only parents (#1372) @izeigerman

🧹 Chore

• Remove print statements (#1373) @eakmanrq

👽 Other

• Remove distinct (#1371) @eakmanrq
• Add extras to installation docs page (#1370) @treysp

v0.29.1

🪲 Bug fixes

• Improvements to Github CI/CD Bot Documentation (#1367) @eakmanrq
• Fallback to the breaking change category if the model's query can't be rendered at parse time and the auto categorization mode is set to FULL (#1369) @izeigerman

🧹 Chore

• Suggest a command to run when raising an error about the need for migration (#1368) @izeigerman