v0.140.1

🪲 Bug fixes

• Always treat forward-only models as non-deployable (#3510) @izeigerman

v0.140.0

✨ Features

• Add an option to pretty sql (#3455) @MikeWallis42
• (cli) Ability to set config CLI params via env vars (#3493) @kelsin
• Make log output more human-friendly (#3496) @plaflamme

🪲 Bug fixes

• Always control error handling of audits in scheduler (#3466) @georgesittas
• (athena) Drop partitions in batches of 25 (#3488) @erindru
• Make create_external_models behave like other SQLMesh commands with respect to --gateway (#3453) @erindru
• Prevent unintentional table schema changes during evaluation (#3487) @izeigerman
• Make signals serializable (#3480) @tobymao
• Quote the table produced by _resolve_table (#3494) @georgesittas
• (bigquery) Pass catalog when checking for clustering key changes (#3498) @erindru

🛠️ Refactor

• Make when_matched syntax compatible with merge syntax (#3497) @georgesittas

🧹 Chore

• Move list of non-context commands to constant (#3485) @kelsin
• Bump sqlglot to v25.34.0 (#3482) @georgesittas
• Fix logger warning small typo (#3489) @themisvaltinos
• Fix faulty test (#3490) @erindru
• Address flaky Redshift test (#3491) @erindru
• Document clearing out history of scd type 2 model (#3495) @eakmanrq
• Cleanup @tobymao
• Update readthedocs python from 3.8 to 3.10 (#3504) @treysp

👽 Other

• Some tiny docs fixes as I find them (#3483) @djayatillake
• Cloud data catalog (#3478) @caiters
• Add Snowflake Tracking (#3492) @sungchun12
• Cloud overview page (#3473) @mesmith027
• Use image with white background on tcloud landing page (#3499) @treysp

v0.136.2

🪲 Bug fixes

• Always treat forward-only models as non-deployable (#3510) @izeigerman

v0.138.1

🪲 Bug fixes

• (bigquery) Pass catalog when checking for clustering key changes (#3498) @erindru

v0.139.0

✨ Features

• Update CLI plan command's create environment message (#3397) @treysp

🪲 Bug fixes

• Remove top level pyspark imports (#3458) @eakmanrq
• Apply cast-to-dcolon rule for every model statement (#3463) @georgesittas
• Consider sqlmesh major/minor for migrate and rollback (#3446) @MikeWallis42
• Use python 3.9 for airflow dockerfile template (#3476) @georgesittas
• UI task position (#3470) @MikeWallis42

🛠️ Refactor

• Move creation of snapshots into own method (#3471) @benfdking

🧹 Chore

• Deprecate python 3.8, use public API for magics arg parsing (#3468) @georgesittas
• Move model selection for runs into a separate method (#3474) @izeigerman

👽 Other

• Tobiko Cloud Getting Started Docs (#3424) @sungchun12
• Evolve language to complement website (#3467) @sungchun12
• Debugger View Docs (#3429) @sungchun12

v0.138.0

✨ Features

• Add multiple engine project support (#3394) @themisvaltinos

🪲 Bug fixes

• Httpx usage for 0.28.0 (#3440) @erindru
• (athena) Fix error replacing partitions in Hive tables where the partition column is a date / timestamp type (#3441) @erindru
• Enable concurrency in DuckDB (#3430) @erindru
• Use string func in surrogate key macro (only md5 at the moment) (#3448) @georgesittas
• Use model dialect as fallback for audits (#3447) @georgesittas
• Store a Table in @this_model var instead of its str representation (#3457) @georgesittas
• (mysql) Use LONGTEXT data type when storing large blobs of text (#3442) @MikeWallis42
• Import for workers (#3454) @mykalmax

🧹 Chore

• Fix typing and imports for ci/cd (#3450) @treysp

👽 Other

• Add installation info to dbt quickstart (#3449) @treysp
• Fix ClickHouse capitalization (#3452) @treysp
• Tobiko cloud docs structure (#3418) @mesmith027

v0.137.1

🪲 Bug fixes

• Python model macros (#3435) @tobymao

v0.137.0

✨ Features

• Add support for comparing nested BigQuery values (structs, arrays) (#3428) @georgesittas

🪲 Bug fixes

• Rename docs to catalog to keep routes consistent (#3391) @mykalmax
• Add CASCADE modifier when dropping columns in Postgres / Redshift (#3427) @izeigerman
• Round columns percentage stats to 9th decimal (#3432) @esciara

🧹 Chore

• Adding "source" to model types (#3425) @caiters
• Bump sqlglot to v25.32.1 (#3434) @georgesittas

v0.136.1

🛠️ Refactor

• Refactor promote and demote into method (#3421) @benfdking

v0.136.0

✨ Features

• Add an option to not run upstream dependencies when selecting models in the command (#3413) @izeigerman

🪲 Bug fixes

• Dbt tests for relation and column types (#3415) @izeigerman
• Make the mapping of the dbt's on_schema_change property more conservative (#3414) @izeigerman
• Support coercion of BIGNUMERIC values into FLOAT64 for BigQuery (#3417) @izeigerman

👽 Other

• Add Video Example (#3416) @sungchun12