v0.118.6

✨ Features

• Improve environment loading performance by lazy evaluating snapshot and snapshot id fields (#3038) @crericha
• Allow creating environments without changes when using selector (#3060) @izeigerman

🪲 Bug fixes

• Cache inclusive exclusive for performance (#3057) @tobymao
• Ignore expired environments in the selector (#3059) @izeigerman

v0.118.5

🪲 Bug fixes

• Heuristics that determine the default start date of the forward-only preview plan (#3043) @izeigerman
• Test failure caused by a new version of rich (#3053) @izeigerman
• Don't process models that have already been processed (#3052) @tobymao

🧹 Chore

• Treat the target environment as missing during planning if it's expired (#3051) @izeigerman

v0.118.4

🪲 Bug fixes

• User-provided plan end must take precedence over the max interval end per model (#3042) @izeigerman

v0.118.3

🪲 Bug fixes

• Don't cache snapshot intervals (#3041) @izeigerman

v0.118.2

✨ Features

• Implement SQLMesh native date spine macro (#2990) @sungchun12
• Add jinja call cache to improve loading performance (#3030) @tobymao
• Allow a single macro function call in model definitions (#3032) @georgesittas

🪲 Bug fixes

• Introspect function defaults to extract global refs for serialization (#3028) @georgesittas
• Only include used refs into jinja globals when converting dbt models (#3033) @izeigerman

🧹 Chore

• Make connection creation consistent (#3027) @eakmanrq

👽 Other

• Move page table of contents to right side (#3029) @treysp

v0.118.1

🪲 Bug fixes

• Updating model in the integration test @izeigerman

🧹 Chore

• Improve the test_select_unchanged_model_for_backfill integration test @izeigerman

v0.118.0

✨ 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

🪲 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

🧹 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

👽 Other

• Create snowflake comments in bulk (#2991) @ananis25
• Update python pre/post statements (#3000) @Themiscodes

v0.117.0

✨ 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

🪲 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

🧹 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

👽 Other

• Add snowflake connection quickstart (#2981) @treysp

v0.116.0

✨ Features

• Add support for dbt adapter method quote_as_configured (#2970) @crericha

🪲 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

🧹 Chore

• Run cloud engines after docker engines (#2972) @erindru

👽 Other

• Add databricks connection quickstart (#2957) @treysp
• Deduplicate SQLMesh Native Macro (#2960) @sungchun12

v0.115.1

🪲 Bug fixes

• Conditional statement parsing edge case (#2967) @georgesittas

👽 Other

• Use sqlmesh blue for header and links (#2966) @treysp