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

v0.115.0

✨ Features

• Helpful err msg if forward_only specified in incremental by partition (#2950) @treysp
• Add GenericNotificationTarget to NotificationTargets (#2944) @kam-cheng-emis

🪲 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

🧹 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

👽 Other

• Lazy load images (#2954) @treysp
• Correct airflow state connection info in configuration guide (#2963) @treysp
• Minor FAQ updates (#2964) @treysp

v0.114.0

✨ Features

• Expose Snowflake dynamic tables through the DBT adapter (#2942) @erindru
• Support enabling audits in model defaults (#2947) @Themiscodes

🪲 Bug fixes

• Support unordered columns in test data generation query (#2920) @Themiscodes
• Set DebuggerTerminalConsole verbose to false (#2923) @treysp

🧹 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

👽 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

v0.107.6

🪲 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

v0.113.0

✨ Features

• Warn when state connection uses a non-recommended engine (#2919) @treysp
• Allow disabling airflow state migrations (#2921) @eakmanrq
• Add support for defaults in user audits (#2901) @alexischicoinedatadeveloper

🪲 Bug fixes

• Allow overriding built-in datetime vars in tests (#2916) @treysp
• Coercion of string to integers when converting csv to agate tables (#2918) @izeigerman
• Ensure Python models are backed by tables and not views (#2908) @erindru
• Only backfill modified models in the dev plan if unmodified models are not included (#2917) @izeigerman

🧹 Chore

• Update managed table docs (#2922) @erindru

👽 Other

• Clean up model properties in concepts overview and model config reference (#2913) @treysp

v0.107.5

🪲 Bug fixes

• Coercion of string to integers when converting csv to agate tables (#2918) @izeigerman

v0.112.0

✨ Features

• Pass session parameters for Snowflake (#2912) @alexischicoinedatadeveloper

🪲 Bug fixes

• Ignore the warehouse property on non-dynamic tables (#2911) @erindru
• Snowflake adapter (#2870) @erindru
• Bump sqlglot 25.6.0 (#2915) @eakmanrq

v0.111.0

✨ 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

🪲 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

👽 Other

• Add description for the environment_catalog_mapping setting to the configuration reference (#2906) @izeigerman