v0.142.2

✨ Features

• Provide useful error for invalid model kind (#3581) @treysp

🪲 Bug fixes

• Restatement of models that are present in prod but are missing in dev (#3589) @izeigerman

🧹 Chore

• Condense completion messages (#3563) @treysp

v0.142.1

🪲 Bug fixes

• Unpaused snapshots that are downstream of snapshots with enabled auto-restatement can still be representative (#3584) @izeigerman

v0.142.0

✨ Features

• (dlt) Add support for generation of nested dlt tables (#3547) @themisvaltinos

🪲 Bug fixes

• Remove os-specific strftime format character (#3559) @treysp
• Support nested variables in dbt projects (#3569) @izeigerman
• Show diff for metadata changes in the plan output (#3574) @izeigerman
• Always create views in the virtual layer for expired environments (#3575) @izeigerman
• Add adapters for commands that are not using the snapshot evaluator (#3531) @themisvaltinos
• Don't drop intervals in state when restating models in a dev environment (#3580) @izeigerman

🧹 Chore

• Deprecate pydantic v1 (#3548) @georgesittas
• Fix the lock file name in docs (#3549) @izeigerman
• Remove the unused variable in the run_merged_intervals method (#3550) @izeigerman
• Move application of pending restatement intervals into the Snapshot class (#3551) @izeigerman
• Disable date prompts by default when running the plan command (#3568) @izeigerman
• Fix the Airflow e2e test @izeigerman
• Set run_on_deploy_to_prod to false by default for the CICD bot (#3572) @izeigerman

👽 Other

• Update incremental by unique key docs with merge_filter (#3560) @themisvaltinos
• Add contribution commands for docs (#3571) @seanpwlms
• Minor updates (#3570) @seanpwlms

v0.141.1

🧹 Chore

• Move application of pending restatement intervals into the Snapshot class (#3551) @izeigerman

v0.141.0

✨ Features

• Support AzureSQL (#3509) @treysp
• Allow macro functions in when_matched property (#3527) @georgesittas
• Add this_model property in the macro evaluator to return a string (#3528) @georgesittas
• Support 'optimize' flag in model defs (#3512) @VaggelisD
• Add multiple catalogs functionality to MotherDuck connection (#3484) @naoyak
• Add support for auto-restatements (#3529) @izeigerman
• Exclusions in selector powered by full parsing (#3535) @tobymao
• Do recursive glob matching for ignore_patterns (#3539) @georgesittas
• Add ability to exclude dependencies in the requirements lock file (#3544) @izeigerman
• Improve message when no models are ready to run (#3513) @treysp
• Add support for merge_filter and dbt incremental_predicates for Incremental By Unique Key (#3540) @themisvaltinos

🪲 Bug fixes

• Adapt evaluator test to prevent duplicate macro possibility (#3520) @themisvaltinos
• Propagate dialect to extract call for script loading (#3521) @georgesittas
• Include column descriptions in optimized query cache key (#3532) @georgesittas
• Reject string model names (#3534) @georgesittas
• Ensure that restatements in prod also trigger restatements in dev (#3511) @erindru
• A flaky auto-restatement test (#3541) @izeigerman
• Adapt evaluator test to use unique model names (#3538) @themisvaltinos

🛠️ Refactor

• Remove freezegun dependency in favor of time-machine (#3533) @georgesittas

🧹 Chore

• Switch tests from freezegun to time-machine (#3516) @treysp
• Add missing utc timezone to test (#3526) @eakmanrq
• Fix arg name in Node Field definition (#3530) @treysp
• Fix bigquery integration test (#3536) @georgesittas
• Fix tests that didnt work in non-UTC timezone (#3542) @erindru
• Remove deprecation warning from sushi (#3543) @tobymao

👽 Other

• Check that test_adapter exist before closing (#3518) @Kayrnt

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