v0.201.1

✨ Features

• Tag BigQuery queries with their correlation ID as label (#4861) @VaggelisD
• Correctly handle the generation of VALUES expressions using macros (#4975) @georgesittas

🪲 Bug fixes

• (duckdb) Use CREATE OR REPLACE when registering secrets on cursor init to prevent an 'already exists' error (#4974) @erindru
• Don't use SCD type 2 restatement logic in regular runs (#4976) @themisvaltinos
• Respect env. var for leading comma & normalize format settings (#4978) @georgesittas

v0.197.5

👽 Other

• Bump sqlglot to 26.31.2 @georgesittas

v0.201.0

✨ Features

• (lsp) Return load time errors as diagnostics (#4940) @benfdking
• (vscode) Diagnostic for bad config.yaml error (#4945) @benfdking
• (vscode) Error well on bad config.yaml (#4946) @benfdking
• (vscode) Handle correct config.py with bad config (#4948) @benfdking
• (vscode) Handling python errors well (#4947) @benfdking
• (cicd_bot) Allow forward-only plans based on branch suffix (#4953) @erindru

🪲 Bug fixes

• Make repr deterministic for fingerprinting (#4925) @eakmanrq
• Do not display signal progress if a project has no signals (#4939) @georgesittas
• Add 'ducklake prefix if not present (#4941) @eakmanrq
• Convert to none nan values for test generation (#4942) @themisvaltinos
• Add DATETIMEOFFSET handling in pyodbc for MSSQL (#4930) @mattiasthalen
• Add project in environment statements for consistent multi-repo plans (#4966) @themisvaltinos
• (table_diff) Properly handle null check for array types in data sample (#4963) @erindru
• Allow python models to call resolve_table() on themselves within a unit test (#4967) @erindru
• Preserve actual dataframe indices in unit test output (#4969) @themisvaltinos

🧹 Chore

• Update and clarify blueprints doc example macro syntax (#4951) @themisvaltinos
• (cicd_bot) Show logged warnings/errors in the check output (#4938) @erindru
• Update ci/cd bot default behaviour to match CLI behaviour (#4900) @erindru
• (vscode) Add tests for duplicate model and bad model block (#4954) @benfdking
• (vscode) Test bad audit diagnostic (#4955) @benfdking
• (vscode) Adding tests for bad projects (#4957) @benfdking
• (vscode) Refactoring e2e tests (#4962) @benfdking
• (cicd_bot) Tidy up failure output (#4964) @erindru
• Show resources to be deleted and enhance warnings in destroy (#4965) @themisvaltinos
• Remove private tests while they are reworked (#4968) @eakmanrq

v0.200.0

✨ Features

• Add support for configurable cache directory (#4869) @themisvaltinos
• (cicd_bot) Improve output of 'PR Environment Synced' and 'Prod Plan Preview' steps (#4872) @erindru
• Allow specifying a minimum number of intervals to include for each model in a plan (#4780) @erindru
• Add named secret support DuckDB (#4912) @eakmanrq
• (cicd_bot) Document and enable the min_intervals plan option (#4901) @erindru
• Ability to find a model block (#4933) @benfdking

🪲 Bug fixes

• Check sqlmesh version before sqlglot/schema (#4898) @eakmanrq
• Don't include type when using ducklake (#4913) @eakmanrq
• Always recreate materialized view (#4908) @VaggelisD
• Parse runtime-rendered fields, extract python env deps from merge_filter (#4905) @georgesittas
• Don't remove dev intervals when restating in production environment (#4922) @izeigerman
• Ensure correct datatypes are fetched for RisingWave dialect (#4903) @MisterWheatley
• (cicd_bot) Don't truncate backfill model list (#4915) @erindru
• Establish transaction and session before snapshot promotion/demotion (#4899) @treysp
• Freeze time to make github test determinstic (#4934) @themisvaltinos
• Do not attach correlation_id for Athena queries (#4935) @VaggelisD

🧹 Chore

• (vscode) Improving the playwright setup/teardown steps (#4883) @benfdking
• (vscode) Move to better exec async (#4884) @benfdking
• (vscode) Delete unused code (#4885) @benfdking
• (vscode) Make buttons neater html (#4886) @benfdking
• (vscode) Remove export block (#4887) @benfdking
• (vscode) Typing lineage and storybook (#4888) @benfdking
• (vscode) Delete unused components (#4889) @benfdking
• (vscode) Remove cache from e2e test (#4897) @benfdking
• Move cross-database diffing to Tobiko Cloud features (#4894) @treysp
• Move SSO docs to security section (#4896) @treysp
• (vscode) Lint the tests folder (#4893) @benfdking
• (vscode) Get rid of old way of testing e2e (#4891) @benfdking
• (vscode) Update dependencies (#4890) @benfdking
• Remove observer docs (#4892) @treysp
• Cleaning up lineage (#4907) @benfdking
• (vscode) Update source tree in git (#4909) @benfdking
• (vscode) Continued typing of nodes (#4911) @benfdking
• (vscode) Use uv to speed up e2e tests (#4882) @benfdking
• (vscode) Adding typing to worker message bus (#4918) @benfdking
• (vscode) Separate out building of settings for test (#4919) @benfdking
• (vscode) Sharing server instance between tests (#4920) @benfdking
• Removing timeouts as tests are fast enough now (#4921) @benfdking
• Reintroduce tagging queries with correlation ID (#4895) @VaggelisD
• Make _path optional and more representative (#4303) @benfdking
• Remove dead spark integration code (#4924) @izeigerman
• Don't support string arguments for the 'config_for_node' API (#4926) @izeigerman
• Bump sqlglot to v27.0.0 (#4929) @georgesittas
• (deps) Bump astral-sh/setup-uv from 4 to 6 (#4931) @dependabot[bot]

👽 Other

• Vscode-tutorial (#4923) @sungchun12

v0.197.4

👽 Other

• Bump sqlglot to 26.31.1 @georgesittas

v0.197.3

🪲 Bug fixes

• Don't remove dev intervals when restating in production environment (#4922) @izeigerman

v0.187.10

👽 Other

• Bump sqlglot to 26.21.3 @georgesittas

v0.199.0

✨ Features

• Improve signal CLI UX (#4812) @georgesittas
• (vscode) Add ability to turn on/off columns (#4826) @benfdking

🪲 Bug fixes

• Put limit on lru cache (#4867) @eakmanrq
• Normalize when_matched and merge_filter expressions to the source dialect (#4847) @erindru
• (vscode) Allow undoing clicking of lineage columns (#4876) @benfdking
• Make MSSQL merge exists implementation opt-in (#4870) @treysp
• A restatement plan should not override environment statements (#4880) @izeigerman

🧹 Chore

• Speed up tests when running locally (#4863) @benfdking
• (vscode) Starts testing the actual contents of the lineage view (#4865) @benfdking
• Add check for dot env to avoid python env conflicts (#4866) @themisvaltinos
• Make vscode tests less flaky (#4875) @benfdking
• Move SnapshotEvaluator back at plan evaluator constructor (#4877) @VaggelisD
• Refactor the intervals check and move progress reporting into the scheduler (#4879) @izeigerman

👽 Other

• Move all vens to use .venv (#4860) @benfdking

v0.197.2

🪲 Bug fixes

• A restatement plan should not override environment statements (#4880) @izeigerman

v0.198.0

✨ Features

• Tag queries with their plan id (#4832) @VaggelisD
• Add dtntz date macro variant (#4838) @georgesittas

🪲 Bug fixes

• Bug in model creation related to metadata-only statements (#4836) @georgesittas
• (vscode) Fix windows linage graph (#4857) @benfdking
• Execution_time should default to now() (#4852) @treysp

🧹 Chore

• Bump sqlglot to v26.32.0 (#4853) @georgesittas
• (deps) Bump pnpm/action-setup from 2 to 4 (#4855) @dependabot[bot]
• (vscode) Test .env virtual environmnet (#4858) @benfdking
• Bump sqlglot to v26.33.0 (#4859) @georgesittas
• Pin duckdb>=1.2.0 in motherduck extra (#4854) @treysp
• Remove dbt-sqlserver dependencies (#4862) @izeigerman