Sqlmesh

:sparkles: Features
* Support custom schema name for state metadata (1171) eakmanrq
* CI/CD Bot Add Merge Method (1207) eakmanrq
* Respect the model's cron expression in the built-in scheduler (1209) izeigerman
* Make interval unit configurable per model (1213) izeigerman
* Add physical schema override (1212) eakmanrq
* Allow specifying of arbitrary table properties as part of the model definition (1217) izeigerman
* Initial pass of SQLMetrics (1221) tobymao

:beetle: Bug fixes
* Use VARCHAR instead of TEXT for MySQL pks, indexed fields (1208) GeorgeSittas
* Increase timeout-keep-alive and send ping every 15s to browser (1172) mykalmax
* Send cancel plan request when canceling plan (1210) mykalmax
* Remove latest time in favour of execution time (1211) izeigerman
* Allow render output to wrap instead of cropping (1222) z3z1ma
* Parsing of the quoting config (1227) izeigerman
* Enable Hive dynamic partition in Spark session (1228) izeigerman

:hammer_and_wrench: Refactor
* Serialize the source SQL code for each expression (1187) GeorgeSittas

:broom: Chore
* Cleanup tobymao
* Improve the warning message when missing a schema while optimizing a model query (1224) izeigerman

:alien: Other
* Always get merge commit regardless event type (1203) eakmanrq
* Add FAQ (1214) treysp
* Correct select * and model default kind (1216) treysp

:sparkles: Features
* Drop schemas for expired environments (1177) eakmanrq
* Support the '_dbt_max_partition' variable for BigQuery dbt projects (1195) izeigerman

:beetle: Bug fixes
* Use session when creating snapshot tables (1190) izeigerman
* Support insert overwrite with dynamic partitions in the BigQuery adapter (1188) izeigerman
* Fix test (1193) eakmanrq
* Add boolean to fix request params type (1199) mykalmax
* Set forward_only to true by default for the Incremental Unmanaged model kind (1200) izeigerman
* Fix invalidating env test (1201) eakmanrq
* Make sure the evaluation progress bar looks good when evaluating a large number of models (1202) izeigerman

:broom: Chore
* Rename 'target_partitions' variable to something more distinct to avoid potential conflict izeigerman

:alien: Other
* Support both import paths for exceptions (1194) eakmanrq
* Update docs with default dialect specification (1196) treysp
* Introduce the model test API endpoint (1198) vchan

:sparkles: Features
* Introduce an additional 'incremental_unmanaged' model kind to support existing incremental mode in dbt projects (1173) izeigerman
* Support sessions in the BigQuery adapter (1185) izeigerman

:beetle: Bug fixes
* Fix styling for cli reference init (1184) treysp
* Deserialization of the incremental unmanaged model kind izeigerman
* Remove SQL dialect config for dbt projects (1189) treysp

:sparkles: Features
* Require dialect arg in sqlmesh config (1127) treysp
* Add endpoint to get current version + display version in footer (1174) mykalmax

:beetle: Bug fixes
* Tab not showing after refresh + store unsaved changes (1164) mykalmax
* Quote all identifiers in execute except those coming from fetchdf (1128) GeorgeSittas
* Skip directories in a dbt project that the user is not permitted to access (1179) crericha
* Make postgres keepalives_idle optional for dbt projects (1180) crericha
* Make dbt postgresql targeting read database name from profile correctly lu0x1a0

:hammer_and_wrench: Refactor
* Replace snapshot model with snapshot node (1137) crericha

:alien: Other
* Reorder cli quickstart (1168) treysp
* Return an empty array of columns instead of an error when columns_to_types is None (1169) vchan
* Reorder notebook quickstart (1170) treysp
* Add dbt adapter link to install page (1176) treysp
* Remove extra check mark (1182) treysp
* Revert "Remove extra check mark (1182)" (1183) treysp

:beetle: Bug fixes
* Normalize model name, issue for dbt snowflake tobymao
* Fix Windows faulthandler and seed path (1162) eakmanrq
* Allow reverting to previous versions (1163) eakmanrq
* Json bigquery types show up as TYPE_KIND_UNSPECIFIED tobymao

:broom: Chore
* Rename --promote-all to --include-unmodified (1166) izeigerman

:sparkles: Features
* Improve file explorer (1044) mykalmax
* Promote only changed snapshots in dev environments (1131) izeigerman
* Show scrollbar on hover for all scrollable blocks (1141) mykalmax
* Add support for forward_only and disable_restatement flags to incremental models (1144) izeigerman
* Add sorting/filtering to table (1138) mykalmax
* Improve consistent styling for inputs + use radix/select for selectors (1151) mykalmax
* Prettier Slack webhook notifications (1145) z3z1ma
* Add keyboard support to the SearchList component (1143) mykalmax
* Determine time_column from bigquery partition_by config (1153) crericha
* Add ttl to snapshot cache (1158) tobymao
* Add progress bar for snapshot creation (1157) GeorgeSittas
* Re-use ModelConfirmation component from IDE page (1155) mykalmax

:beetle: Bug fixes
* Properly support DataFrames when doing INCREMENTAL_BY_UNIQUE_KEY (1119) eakmanrq
* Normalize model names and dependencies as sqlglot dialect (1126) tobymao
* Populate unittest inputs before rendering query, which may access the input tables (1121) crericha
* Improve SQL syntax in editor (1095) mykalmax
* Migration for view models (1124) izeigerman
* Databricks session_configuration can be None (1129) eakmanrq
* Allow forward-only on added external models (1130) eakmanrq
* Allow partials when loading configs + Personal Config Overrides Project (1136) eakmanrq
* Manually check if sqlglot ready when loading Editor component (1142) mykalmax
* Display compiled query in model docs (1149) mykalmax
* Re-introduce the 'sqlmesh' jinja flag for dbt projects izeigerman
* Skip auto categorization for snapshots that indirectly modify models with missing schema (1147) izeigerman
* Failing tests izeigerman
* Unique type discriminator for GCPPostgresConnectionConfig (1152) crericha
* Only migrate snapshots that are paused (1154) izeigerman
* Missing intervals should not include indirect non breaking tobymao
* Fix windows paths for executables (1156) eakmanrq
* Update the Airflow integration test izeigerman
* Create_external_models refetch existing external models closes 1132 tobymao
* File disappear after dragging + add long press to enable dragging (1159) mykalmax
* Correctly handle missing intervals for forward-only snapshtos when effective_from is set (1160) izeigerman
* Fix the total number of tasks for the snapshot creation progress bar (1161) izeigerman

:hammer_and_wrench: Refactor
* Make sqlmesh incremental blocks more clear (1140) crericha
* Remove hydrating and missing_intervals from state_sync (1116) tobymao
* Make scheduler explicitly take SnapshotIdLike since it refetches from state_sync tobymao

:broom: Chore
* Bump sqlglot to v17.3.0 (1111) GeorgeSittas
* Add type so eslint understands when value is exists (1092) mykalmax
* Updated packages (1134) mykalmax

:alien: Other
* No longer retry bad request (1118) eakmanrq
* Add connection configuration to quickstart next steps (1125) treysp
* Update built-in scheduler description (1123) treysp
* Add connection config for GCP managed Postgres (1146) crericha
* Add promote_all option (1148) mykalmax