v0.18.0

✨ 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

🪲 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

🛠️ 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

🧹 Chore

• Bump sqlglot to v17.3.0 (#1111) @georgesittas
• Add type so eslint understands when value is exists (#1092) @mykalmax
• Updated packages (#1134) @mykalmax

👽 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