Sqlmesh

:sparkles: Features
* Allow returning >1 statements using macros (3004) georgesittas
* Add Databricks Serverless support (3001) eakmanrq
* Make MacroEvaluator.columns_to_types more lenient (3006) georgesittas
* Automatically load signals from the `signals/` subfolder (3010) plaflamme
* Add support for dbt external location in sources meta (2999) Themiscodes

:beetle: Bug fixes
* Make lookback conditional on missing intervals closes 2985 (3002) tobymao
* Builtin pattern matching audits operators (3011) Themiscodes
* Reading boolean columns from CSV files (3014) Themiscodes
* Toby/perf (3008) tobymao
* Properly handle panda columns scd type 2 (3009) eakmanrq
* Exponentially multiplying removed interval records (3016) izeigerman
* Slack user warning :: the top level `text` argument is missing in the request payload (3020) zzztimbo
* Snapshot parsing during migration (3022) izeigerman
* Quote table names closes 3021 (3023) tobymao
* Include models selected for backfill in the virtual layer even if they haven't been changed directly (3024) izeigerman
* Serialization regression with sqlmesh.core.dialect.normalize_model_name (3025) z3z1ma

:broom: Chore
* Remove len == 0 from snowflake _create_column_comments (2993) treysp
* Fix sushi waiters default_catalog capitalization (2994) treysp
* Fix docstring description -> project typo in _Node (2997) georgesittas
* Mention that python model default kind is FULL in model/overview.md (2996) georgesittas
* Remove dead snowflake comment code (2995) treysp
* Fix python model pre/post-statement docs example (3007) georgesittas
* Improve the data model and performance of the state sync (3005) izeigerman
* Set interval end per model in plan (3013) izeigerman
* Introduce the snapshot cache to the state sync (3018) izeigerman
* Bump sqlglot to v25.14.0 (3003) georgesittas
* Bump sqlglot to v25.15.0 (3026) georgesittas

:alien: Other
* Create snowflake comments in bulk (2991) ananis25
* Update python pre/post statements (3000) Themiscodes

:sparkles: Features
* Support macros within audits (2969) Themiscodes
* Include column name in failed column registration warning (2989) treysp
* Support pre-post statements in python models at creation time (2977) Themiscodes

:beetle: Bug fixes
* Send notifications for failing non-blocking audits from the builtin scheduler (2979) crericha
* Ensure Context.close doesn't unnecessarily create a state sync db (2980) georgesittas
* Remove error when deleting expired external model snapshots (2984) eakmanrq
* Regression in Snowflake Python models using Snowpark DataFrame's (2983) erindru
* Add gateway name to model cache identifier (2987) treysp

:broom: Chore
* Improve docs multi repo isolated systems (2982) eakmanrq
* Fix typo in sql_models.md (2986) georgesittas
* Bump sqlglot to v25.10.0 (2992) georgesittas

:alien: Other
* Add snowflake connection quickstart (2981) treysp

:sparkles: Features
* Add support for dbt adapter method quote_as_configured (2970) crericha

:beetle: Bug fixes
* Handle lookback correctly on incremental models with an end date defined (2962) erindru
* Enable loading of Snowflake models that use staged file paths (2973) georgesittas
* Full_refresh is expected to be None as a default value but the v… (2978) tobymao
* Improve handling of the `--where` option in table_diff (2975) erindru

:broom: Chore
* Run cloud engines after docker engines (2972) erindru

:alien: Other
* Add databricks connection quickstart (2957) treysp
* Deduplicate SQLMesh Native Macro (2960) sungchun12

:beetle: Bug fixes
* Conditional statement parsing edge case (2967) georgesittas

:alien: Other
* Use sqlmesh blue for header and links (2966) treysp

:sparkles: Features
* Helpful err msg if forward_only specified in incremental by partition (2950) treysp
* Add GenericNotificationTarget to NotificationTargets (2944) kam-cheng-emis

:beetle: Bug fixes
* Use correct attribute to fetch the dialect from a dbt target (2953) izeigerman
* Use a distinct name for the dbt manifest cache file (2955) izeigerman
* Load external model yaml in subdirs of external_models dir (2956) crericha

:broom: Chore
* Fix migration test (2951) treysp
* Refactor how engine adapter integration tests are run (2926) erindru
* Ensure databricks-connect is actually installed before running Databricks tests (2961) erindru
* Bump sqlglot to v25.8.0 (2959) georgesittas
* Bump sqlglot to v25.8.1 (2965) georgesittas

:alien: Other
* Lazy load images (2954) treysp
* Correct airflow state connection info in configuration guide (2963) treysp
* Minor FAQ updates (2964) treysp

:sparkles: Features
* Expose Snowflake dynamic tables through the DBT adapter (2942) erindru
* Support enabling audits in model defaults (2947) Themiscodes

:beetle: Bug fixes
* Support unordered columns in test data generation query (2920) Themiscodes
* Set DebuggerTerminalConsole verbose to false (2923) treysp

:broom: Chore
* Refactor plan to be more maintainable (2910) tobymao
* Allow make ui-up to take project directory as env variable (2929) treysp
* Add Missing ConnectionConfigs to core.config init (2940) kam-cheng-emis
* Add persistent duckdb gateway to sushi and wursthall examples (2938) treysp
* Upgrade sqlglot (2945) tobymao

:alien: Other
* Enable easy code copying, improve search (2925) treysp
* Clarify and add example to sql model concepts pre/post statements (2924) treysp
* Clarify configuration for separate warehouse and state connections (2931) treysp
* Fix lists in sqlmesh macros concepts (2937) treysp
* Change audit concepts inline notes to callouts (2939) treysp
* Clarify macro variables docs, add examples (2927) treysp
* Fix typed macro example (2946) treysp