Sqlmesh

:sparkles: Features
* Improve audit error message formatting (3818) treysp
* Add [WARNING] to console warning messages (3826) treysp
* Extend support of project wide model properties (3832) themisvaltinos

:beetle: Bug fixes
* **(postgres)** Quote role names if required when running SET ROLE on cursor init (3825) erindru
* Handle quoted projects properly in bigquery adapter (3820) georgesittas
* Don't fail because of an unrestorable change if the target model is forward-only (3835) izeigerman
* Respect disable_restatement remove intervals across env (3838) eakmanrq
* Respect disable restate dev unpaused snapshots (3840) eakmanrq
* Streamline execution of pre- / post- statements when creating a physical table (3837) izeigerman

:broom: Chore
* Fix flaky test (3828) erindru
* Improve metadata update console printing (3824) georgesittas

:alien: Other
* Adding self hosted executor docs (3816) benfdking
* Revert "Fix(postgres): Quote role names if required when running SET ROLE on cursor init" (3834) georgesittas

:sparkles: Features
* Adjust physical_properties evaluation and add macro to resolve physical table names (3772) erindru
* Include alter statements in destructive change error message (3805) treysp

:beetle: Bug fixes
* Propagate the grain attribute when converting dbt models (3804) izeigerman
* Add kwargs to build_table_properties_exp (3817) eakmanrq
* Databricks with_log_level (3823) eakmanrq

:broom: Chore
* Use 'dev' suffix instead of 'temp' for non-deployable physical tables (3803) izeigerman

:alien: Other
* **(dagster)** Fix installation instructions (3812) erindru
* Dagster demo and tutorial video (3822) sungchun12

:sparkles: Features
* Add airflow operator and hook for ClickHouse (3699) Spar9a
* Allow macros in python model properties (3740) themisvaltinos
* Run audits as non-blocking on dev previews (3809) erindru

:beetle: Bug fixes
* Ensure diff sample displays when table names have been uppercased (3806) themisvaltinos
* Update github links for pdoc api docs (3807) gerrykou

:broom: Chore
* Bump sqlglot to v26.6.0 (3810) georgesittas

:alien: Other
* Clarify in faq that run ignores local definitions (3794) treysp
* Update CLI quickstart's CLI output (3802) treysp

:sparkles: Features
* Don't force db connect if using serverless (3786) eakmanrq
* Add 'auditing' and 'promoting' runtime stages (3791) izeigerman

:beetle: Bug fixes
* Ensure unsafe catalog identifiers are quoted before parsed (3789) georgesittas
* Databricks set default catalog for both connections (3793) eakmanrq
* Only promote all snapshots if the target environment expired (3797) izeigerman
* Make sure that physical tables exist for promoted snapshots (3798) izeigerman
* Db properly support `with_log_level` (3799) eakmanrq
* Run integration tests in session (3801) eakmanrq
* Specify init duckdb database so quickstart works (3800) treysp

:broom: Chore
* Replace mysql-connector-python with pymysql (3788) treysp
* Remove [missing dates] from CLI model backfills title (3796) treysp

:alien: Other
* Prod Env Observability updates (3790) mesmith027
* Update jinja gateway variable syntax (3795) treysp

:sparkles: Features
* Don't force db connect if using serverless (3781) eakmanrq

:beetle: Bug fixes
* Change gateway naming and render False values on project init (3774) VaggelisD
* Load multi repo models earlier to ensure schema is correct (3778) tobymao

:broom: Chore
* Bump sqlglot to v26.4.1 (3779) georgesittas
* Address Clickhouse Cloud test flakiness (3782) erindru

:alien: Other
* Give a primer for new tcloud users (3780) sungchun12
* Revert "feat: don't force db connect if using serverless" (3784) izeigerman

:broom: Chore
* Unpin beautifulsoup4 izeigerman