Sqlmesh

:sparkles: Features
* Add support for audit formatting in sqlmesh format (2893) Themiscodes
* Support skipping columns from being matched in table diff (2895) georgesittas
* Support upstream/downstream git selector (2905) eakmanrq
* Support the strict mode when creating external models (2904) izeigerman

:beetle: Bug fixes
* Allow mysql to not have default catalog behind (2881) eakmanrq
* Avoid type coercion when converting pandas dataframes to agate tables in the dbt adapter (2897) izeigerman
* Override python env's variables with unit test vars when present (2898) georgesittas
* Make sure that views are not recreated unnecessarily in the face of concurrent plan application (2899) izeigerman
* Using macros with IGNORE NULLS (2903) izeigerman
* Quote columns when getting column level lineage (2907) vchan

:alien: Other
* Add description for the environment_catalog_mapping setting to the configuration reference (2906) izeigerman

:beetle: Bug fixes
* Include external models in mapping of context.table (2882) Themiscodes
* Control python model loading with enabled flag (2891) Themiscodes
* Improve cron message to use faster/slower (2883) eakmanrq
* Invalidate the cached model's rendered query after updating the mapping schema (2884) izeigerman

:broom: Chore
* Update python model docs to include audit example (2888) georgesittas
* Improve error reporting when loading seeds (2892) georgesittas

:sparkles: Features
* Signals for the built-in scheduler (2822) plaflamme
* Support dbt model versioning (2874) izeigerman
* Add support for parameterization of model names in unit tests (2879) georgesittas

:beetle: Bug fixes
* Check for null or duplicate primary keys when running table_diff (2840) Themiscodes
* Move metadata only macro funcs from model's data hash to metadata hash (2862) vchan
* Update macro arg. resolution test to fix CI (2873) georgesittas
* Support for trailing comments in SQL model definitions (2863) izeigerman
* Duplicate columns in table diff query (2861) na399
* Normalize excluded columns in STAR macro, fix except_ logging (2880) georgesittas
* Normalization issue in table diff (2872) Themiscodes

:broom: Chore
* Bump sqlglot to v25.5.1 (2868) georgesittas

:alien: Other
* Clarify the scheduler type value for each support scheduler configuration (2878) izeigerman

:beetle: Bug fixes
* Set the lower bound for the hyperscript dependency (2864) izeigerman
* Stop leaking temporary tables in the Snowflake adapter (2865) erindru
* Cast NULLs in VALUES clause (df->values) to avoid coercion issues (2856) georgesittas

:broom: Chore
* Update docs support rest catalog (2860) eakmanrq

:beetle: Bug fixes
* Support the compare_dbr_version in the dbt adapter (2858) izeigerman
* Allow overriding gateway configuration in dbt project config (2857) izeigerman
* In dbt config only set the default_gateway if gateways were not provided izeigerman
* Support for custom SQLMesh gateways in the dbt project config (2859) izeigerman

:broom: Chore
* Refactor Airflow engine operators (2854) izeigerman

:sparkles: Features
* Managed models (2809) erindru
* Add mysql operator for airflow scheduler (2843) kaijie-qin
* Allow users to configure high watermark sensor behavior (2850) eakmanrq
* Allow the janitor to be run on-demand (2844) erindru
* Increase default type precision in redshift/mssql view workaround (2791) treysp
* Support batch_size, batch_concurrency, and lookback attributes in the custom model kind (2852) izeigerman

:beetle: Bug fixes
* Take the default_gateway into account when loading external models (2842) erindru
* Set the dbt invocation context before loading the profile (2846) izeigerman
* BIGNUMERIC column can't be altered into FLOAT64 in BigQuery (2848) izeigerman
* Drop dev previews of managed tables correctly (2849) erindru
* Use the default dialect when constructing a table mapping key in the dbt adapter (2853) izeigerman
* Correct quoting of identifiers in the dbt adapter izeigerman

:broom: Chore
* Fix typo in SQLMeshTrinoOperator.get_db_hook docstring (2845) georgesittas

:alien: Other
* Fix docs for incremental model kinds izeigerman
* Expand custom materializations guide (2851) treysp