v0.101.1

🪲 Bug fixes

• Render audit condition when used in a @where(@condition) clause (#2713) @georgesittas
• Yet another edge case related to snowflake staged file syntax (#2714) @georgesittas
• We can't inspect built-in routines to get their file (#2720) @georgesittas

🧹 Chore

• Update ibis example (#2719) @georgesittas
• Add missing semicolon after MODEL statement in Table Migration docs (#2721) @schlich

v0.101.0

✨ Features

• Databricks allow disabling spark session (#2703) @eakmanrq

🪲 Bug fixes

• Avoid using concat_ws when there's only one key is present (#2711) @izeigerman

🧹 Chore

• Allow to skip connection testing in the 'info' command (#2705) @izeigerman
• Bump sqlglot to v24.1.0 (#2708) @georgesittas
• Include the user agent information as part of the MotherDuck connection config (#2706) @izeigerman

👽 Other

• Update info magic help string (#2707) @treysp

v0.100.2

🪲 Bug fixes

• (motherduck) Filter on catalog name in DuckDB _get_data_objects query (#2699) @treysp
• Exclude private key from the state sync fingerprint calculation (#2704) @izeigerman

🧹 Chore

• Fix typo @tobymao

👽 Other

• Add UI guide (#2700) @treysp

v0.100.1

🧹 Chore

• Ping sqlglot to 24.0.2 @izeigerman

v0.100.0

✨ Features

• Snowpark (#2666) @tobymao
• Introduce INCREMENTAL_BY_PARTITION model kind (#2687) @izeigerman

🪲 Bug fixes

• Allow partial query results in unit tests, update docs (#2676) @georgesittas
• Add missing reporting for builtin runs (#2675) @izeigerman
• For MSSQL apply the same workaround for the varchar size as we use for Redshift (#2674) @izeigerman
• Correct destructive change error messages (#2678) @treysp
• Use exp.column when casting seed columns to avoid ParseError (#2686) @georgesittas
• Unescape sequences in CSV settings (#2690) @georgesittas
• Remove remaining dynamic overwrite modes (#2692) @eakmanrq
• Ensure MacroEvaluator.columns_to_types returns types as DataTypes (#2694) @georgesittas

🧹 Chore

• Add google analytics to docs (#2682) @treysp
• Update unit test docs to include specifying query as fallback (#2683) @georgesittas
• Update docs for ui formatter option (#2685) @simonprydden
• Allow usage of start_* / end_* macros in SCD2 models (#2691) @izeigerman
• Don't store the seed's content in the state (#2688) @izeigerman
• Fix airflow tests @izeigerman

👽 Other

• Add csv_settings to seed models concepts doc (#2679) @treysp
• Clarify incremental by unique key in kinds concepts doc (#2680) @treysp
• Add docs for incremental by partition model kind (#2695) @treysp

v0.99.0

✨ Features

• Extend CSV support with settings; update test docs (#2663) @Themiscodes

🪲 Bug fixes

• Propagate normalized snapshot name to differ (#2673) @z3z1ma

🧹 Chore

• Set the lower bound for the dbt-sqlserver dependency (#2670) @izeigerman
• Use ping to validate connections (#2652) @eakmanrq

v0.98.0

✨ Features

• Improve the CLI output of the table diff command (#2644) @izeigerman
• Forward-only changes schema modification check (#2576) @treysp
• Add support for CSV input data loading from file or inline (#2640) @Themiscodes
• Enable duckdb>=0.10 comment registration (#2660) @treysp

🪲 Bug fixes

• Fix pytest warning on test fixture (#2648) @erindru
• Stop column description propagation if model cannot be found. (#2649) @vchan
• Correctly handle dependency in the migration test (#2651) @izeigerman
• Fix test runner not displaying dots for successes (#2656) (#2657) @giovannipcarvalho
• Delete intervals in batches during compaction (#2658) @izeigerman

🧹 Chore

• Bump sqlglot to v24.0.0 (#2647) @treysp
• Include local sqlmesh configs in integration test context (#2650) @treysp
• Exclude the 0.10.3 duckdb release (#2659) @izeigerman

v0.97.0

✨ Features

• Unpin motherduck duckdb version (#2628) @treysp
• Print warning when except_ is used in @star, add exclude arg (#2639) @georgesittas
• Introduce support for 'pre ping' to detect stale or lost connections (#2632) @izeigerman
• Github CI/CD Bot Allow Overriding PR Environment Name (#2643) @eakmanrq

🪲 Bug fixes

• Disable analytics in tests (#2620) @izeigerman
• Do not visit nodes that are not tables during CLL generation (#2622) @vchan
• Don't lower selection (#2623) @eakmanrq
• Include virtual properties into the metadata hash (#2630) @izeigerman
• Take batch_size into account when filling snapshots for INCREMENTAL_BY_UNIQUE_KEY models (#2616) @erindru
• Hive version in the Airflow docker image @izeigerman

🛠️ Refactor

• Clean up some sections in the unit test module (#2619) @georgesittas
• Simplify conditional statement parsing (#2627) @georgesittas

🧹 Chore

• Add user agent to databricks connections (#2625) @eakmanrq
• Update databricks documentation wording (#2624) @eakmanrq
• Pass dialect in builders used within sushi python models (#2629) @georgesittas
• Bump sqlglot to v23.16.0 (#2633) @georgesittas
• Bump sqlglot to v23.17.0 (#2636) @georgesittas
• Enforce consistent indentation in docs (#2638) @georgesittas
• Refactor unit test docs (#2637) @georgesittas

👽 Other

• Add note about vscode widgets and ipywidgets version (#2621) @treysp
• Add model start default value to configuration reference (#2631) @treysp

v0.96.1

🪲 Bug fixes

• Rename 'sqlmesh' to 'sqlmesh_version' @izeigerman

v0.96.0

✨ Features

• Enable anonymized analytics for the SQLMesh core (#2602) @izeigerman

🪲 Bug fixes

• Fallback logic for when the inspect.stack() call fails (#2617) @izeigerman

🧹 Chore

• Split up get snapshots operations (#2615) @eakmanrq

👽 Other

• Add BigQuery Permissions (#2614) @sungchun12