v0.123.1

🪲 Bug fixes

• Dbt import issue (#3149) @Themiscodes

v0.123.0

✨ Features

• Support external model dialects closes #3135 (#3136) @tobymao
• Add SQLMesh warning when an exp.Command is parsed (#3138) @VaggelisD
• Support mixed multi-repo SQLMesh and dbt projects (#3122) @Themiscodes

🪲 Bug fixes

• Recursively transform dataframe values when converting to a query (#3129) @georgesittas
• Catch optimize errors and log path (#3134) @tobymao
• Correctly generate when_matched SQL (#3141) @eakmanrq
• Types (#3131) @etonlels
• Don't error when same signal factory loaded twice (#3144) @treysp
• Variadic argument issue in loaders (#3147) @Themiscodes

🧹 Chore

• Rescope lineage cache in tests (#3132) @eakmanrq

👽 Other

• Fix folder name (#3133) @serkef
• Clarify that time_column and macro vars are UTC (#3130) @treysp
• Fixed daemon detection to determine forking behavior (#3140) @sammywachtel
• Revert "Fixed daemon detection to determine forking behavior" (#3146) @tobymao

v0.122.2

🪲 Bug fixes

• Have ui be loadable again (#3127) @eakmanrq

v0.122.1

✨ Features

• Support multiple when matched inc unique key (#3124) @eakmanrq

🪲 Bug fixes

• Switch from pooling to default method to detect changes (#3113) @mykalmax

🧹 Chore

• Try fix web app test flakiness (#3126) @eakmanrq

v0.122.0

✨ Features

• Add physical_schema_mapping property and deprecate physical_schema_override (#3108) @erindru
• Materialized view support clustered by and partitioned by (#3117) @eakmanrq

🪲 Bug fixes

• Dont clone managed tables to create dev previews (#3099) @erindru

🧹 Chore

• Use factory method to create builtin scheduler (#3114) @crericha
• Introduce the evaluatable version of a plan object (#3118) @izeigerman
• Refactor the scheduler API to support running of precomputed missing intervals (#3120) @izeigerman

v0.121.1

🪲 Bug fixes

• Databricks properly handle missing is_serverless env var (#3101) @eakmanrq
• Allow overriding blocking setting of builtin audits (#3106) @georgesittas
• Make sure signals are loaded when running models (#3107) @izeigerman
• Allow macros in set operations (#3103) @VaggelisD
• Support dbt sqlserver 1.8.0 (#3112) @eakmanrq

🧹 Chore

• Use external github image links in README (#3111) @treysp

v0.121.0

✨ Features

• Support plan builder class overriding in context (#3078) @georgesittas
• Dry run flag alias (#3091) @sungchun12
• Improve cold start of snapshot cache with multi processing (#3084) @tobymao
• Support BigQuery nested column additions without dropping (#3082) @Themiscodes
• Format check (#3073) @etonlels

🪲 Bug fixes

• Set columns attribute for python models that generate sql (#3087) @ravenac95
• Macro function comments closes #3088 (#3093) @tobymao
• Disable airflow multiprocessing (#3097) @tobymao

🧹 Chore

• Add retries on engine adapter integration tests (#3090) @erindru
• Bump sqlglot to v25.20.1 (#3100) @georgesittas

v0.118.8

✨ Features

• Use multiprocessing to speed up loading (#3077) @tobymao
• Improve cold start of snapshot cache with multi processing (#3084) @tobymao

🪲 Bug fixes

• Disable airflow multiprocessing (#3097) @tobymao

v0.120.0

✨ Features

• Use multiprocessing to speed up loading (#3077) @tobymao

🪲 Bug fixes

• Always provide feedback during plan execution (#3071) @plaflamme
• Support for unique key expressions for SCD2 by column models (#3075) @izeigerman
• Prepopulate the model's depends on in-memory cache for converted dbt models (#3074) @izeigerman
• Properly nested update gateway configs (#3085) @eakmanrq

🧹 Chore

• Isolate web tests (#3076) @vchan
• Update SQLMesh and Tobiko logos to the new style in header and favicon (#3079) @caiters
• Bump sqlglot to v25.19.0 (#3083) @georgesittas

v0.119.0

✨ Features

• Improve table diff sample output in CLI (#3017) @Themiscodes
• Improve environment loading performance by lazy evaluating snapshot and snapshot id fields (#3038) @crericha
• Allow creating environments without changes when using selector (#3060) @izeigerman
• Add clickhouse engine adapter (#3019) @treysp

🪲 Bug fixes

• Skip loading context on run closes #1511 (#3037) @tobymao
• Rename renderer cache so it's not serialized (#3039) @tobymao
• Don't cache snapshot intervals (#3041) @izeigerman
• User-provided plan end must take precedence over the max interval end per model (#3042) @izeigerman
• Add path to Invalid model definition error, fixes #3040 (#3045) @akv-akv
• Heuristics that determine the default start date of the forward-only preview plan (#3043) @izeigerman
• Allow omitting the MODEL (...) block when name inference is activated (#3049) @georgesittas
• Test failure caused by a new version of rich (#3053) @izeigerman
• Don't process models that have already been processed (#3052) @tobymao
• Seed and model column mismatch due to normalization (#3036) @Themiscodes
• Handle missing source target aliases in sample data diff (#3046) @Themiscodes
• (bigquery) Do not use execution_project as default catalog in partitions query (#3056) @treysp
• Handle metaprogramming inspect.getfile TypeError (#3058) @georgesittas
• Cache inclusive exclusive for performance (#3057) @tobymao
• Ignore expired environments in the selector (#3059) @izeigerman
• Retain indexes when creating state table backups (#3061) @izeigerman

🧹 Chore

• Document batch_concurrency for unique_by_key closes #3031 (#3034) @tobymao
• Bump sqlglot to v25.17.0 (#3048) @georgesittas
• Treat the target environment as missing during planning if it's expired (#3051) @izeigerman

👽 Other

• Document unavailable schema placeholder for sqlmesh macros (#3035) @georgesittas
• Beautify README (#3068) @sungchun12
• Move README images to docs/readme/ (#3069) @treysp