v0.145.0

✨ Features

• (redshift) Add native Merge support for Redshift (#3607) @themisvaltinos
• Use source list component to display list of models (#3380) @mykalmax

🪲 Bug fixes

• Properly include dialect when formatting (#3596) @mykalmax
• Don't set the is_incremental flag for non-incremental dbt models (#3616) @izeigerman
• Physical view not being created when needed for non-deployable indirect non-breaking snapshots (#3619) @izeigerman
• Preserve file changes when navigating tabs (#3587) @mykalmax
• The inference of the default plan start (#3628) @izeigerman
• Reduce parsing overhead and improve performance when unpausing snapshots deployed to prod (#3627) @izeigerman

🧹 Chore

• Fix tag docs @tobymao
• Bump sqlglot to v26.1.3 (#3625) @georgesittas
• Fix python model audit docs (#3632) @georgesittas

👽 Other

• Clarify "sqlmesh init" usage (#3617) @techieshark
• Clarify interval_unit definition and use in lookback/batch size (#3613) @treysp
• Docs for dwh cost estimates and savings (#3554) @caiters

v0.142.4

🪲 Bug fixes

• Don't set the is_incremental flag for non-incremental dbt models (#3616) @izeigerman
• The inference of the default plan start (#3628) @izeigerman

v0.144.0

✨ Features

• Add support for on_virtual_update statements (#3524) @themisvaltinos

🪲 Bug fixes

• Access SIGUSR1 using fully-qualified path to avoid windows issue (#3605) @georgesittas
• Use dialect when freezing current date/time values in tests (#3604) @georgesittas
• Stop mutating model.when_matched in merge strategy (#3608) @georgesittas
• The interval unit can be larger than cron perid of allow_partials is set to true (#3609) @izeigerman
• This_model macro usage in the on_virtual_update statements (#3611) @izeigerman
• Calculate when next model ready to run correctly (#3612) @treysp

v0.143.1

🪲 Bug fixes

• Move rendering for merge_filter to evaluation time (#3579) @themisvaltinos
• Change SQLMESH__AIRFLOW__DISABLE_STATE_MIGRATION var name (#3592) @lafirmm
• Make sure downstream models for which restatements are disabled are not auto-restated (#3597) @izeigerman

👽 Other

• Document the cloud scheduler feature (#3567) @izeigerman
• Fix cloud scheduler headers (#3595) @treysp
• Scheduler facade docs (#3558) @erindru

v0.142.3

🪲 Bug fixes

• Make sure downstream models for which restatements are disabled are not auto-restated (#3597) @izeigerman

v0.143.0

🪲 Bug fixes

• Models with allow_partials set to true should respect cron (#3577) @izeigerman
• Plan physical tables progress bar (#3578) @treysp
• (clickhouse) Specify DateTime64 precision for model partitioning expression (#3582) @treysp
• Automatically categorize python models by default (#3594) @izeigerman

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