v0.72.0

✨ Features

• Add invalidate hard delete support to scd type 2 (#2132) @eakmanrq
• Keep track of the previous finalized snapshots in the environment (#2130) @izeigerman
• Ignore SQL model unit test row order unless query contains ORDER BY (#2133) @treysp
• Automatically create non-blocking copies of builtin audits (#2136) @vchan

🪲 Bug fixes

• Motherduck only supports duckdb==0.9.2 (#2134) @treysp
• Lineage (#2059) @vchan
• Make sure that missing intervals don't exceed the target end date when applying plan (#2142) @izeigerman
• Make sure that builtin dbt macros can be referenced using the 'dbt.' prefix (#2143) @izeigerman

🧹 Chore

• Bump sqlglot to 21.1.1 (#2135) @georgesittas

👽 Other

• Transpile default catalog for DuckDB test connection (#2131) @treysp

v0.71.0

✨ Features

• Include sqlmesh in version check (#2125) @eakmanrq

🪲 Bug fixes

• Add missing tstz variable (#2124) @eakmanrq
• Add missing change categories (#2126) @mykalmax
• Use microsecond level precision for inclusive end dates (#2128) @tobymao
• Synchronize selected environment in all tabs (#2127) @mykalmax

👽 Other

• Differentiate seed date and datetime types (#2122) @treysp

v0.70.0

✨ Features

• Allow configuring default formatting behavior in the UI via sql… (#2064) @z3z1ma
• Macro typing coercion (#2041) @z3z1ma
• Virtualized docs list, auto scroll to active item on refresh (#2082) @caiters
• Add dbt scd type 2 feature flag (#2085) @eakmanrq
• Add support for the synchronous mode to the 'invalidate' CLI command (#2098) @izeigerman
• Automatically compute previews for changed forward-only models in dev (#2108) @izeigerman
• Add SCD Type 2 Column Support (#1997) @eakmanrq
• Add tstz support (#2121) @eakmanrq

🪲 Bug fixes

• Do not convert missing seed string column values to string (#2086) @treysp
• Show errors in preview only with lineage/table/diff (#2083) @mykalmax
• Slightly improve model autocompletion (#2043) @mykalmax
• Use correct root path when listing files with git (#2087) @izeigerman
• Clean up SourceList component (#2092) @mykalmax
• Improve perf by lazy loading models list (#2094) @mykalmax
• Add Go Back button to plan flow (#2100) @mykalmax
• Airflow use model name instead of snapshot name (#2095) @eakmanrq
• Select file and add tab we no tabs present (#2096) @mykalmax
• Set min-width for split panes (#2097) @mykalmax
• Control autocompletion manually (#2099) @mykalmax
• Have modules navigation in sidebar (#2102) @mykalmax
• Init bigquery with correct type (#2110) @eakmanrq
• When plan running dont error and just drop (#2115) @mykalmax
• Send message on plan cancel progress (#2116) @mykalmax
• Various clean ups (#2114) @mykalmax
• Styling (#2118) @mykalmax
• Support a missing value for an explicitly provided 'vars' key (#2117) @izeigerman
• Use space instead of T for timestamp format (#2119) @eakmanrq
• Improve lineage flow (#2062) @mykalmax

🧹 Chore

• Add a unit test for the git selector expressions @izeigerman
• Add airflow test to develop doc (#2090) @eakmanrq
• Bump sqlglot to v21.0.0 (#2101) @georgesittas
• Use node for name instead of model (#2105) @eakmanrq
• Scope log handlers to modules (#2106) @eakmanrq
• Fix pydantic 1 support with new type (#2111) @eakmanrq
• Test CLI plan/run commands (#2091) @treysp
• Bump dev dbt duckdb (#2123) @eakmanrq

👽 Other

• Add comment registration default arg to configuration reference (#2088) @treysp
• Revert "Feat: Macro typing coercion (#2041)" (#2089) @eakmanrq
• Ibis example project (#2084) @andrew-sha
• Update README.md (#2103) @tobymao
• Update LICENSE (#2104) @tobymao
• Improve configuration guide environment view schema and catalog (#2120) @treysp

v0.69.5

🪲 Bug fixes

• Use correct root path when listing files with git (#2087) @izeigerman

v0.69.4

✨ Features

• Format slack messages in all cases (#2058) @plaflamme
• Support default catalog overrides in the Airflow scheduler config (#1985) @izeigerman
• Add support for MotherDuck (#2067) @izeigerman
• Make editor inspector collapsable on click (#2018) @mykalmax
• Extend selector with ability to select models that are different from the git main branch (#2078) @izeigerman

🪲 Bug fixes

• Bring nodes forward on lineage (#2057) @mykalmax
• Remove pydantic 2.6 restriction (#2049) @eakmanrq
• Exclude non-model references from the selector's output (#2068) @izeigerman
• Protected against invalid backfill model names in the plan builder @izeigerman
• Do not include a schema def in CTAS unless all column types are known (#2063) @treysp
• Display all values from deleted rows (#2042) @mykalmax
• Tune-up editor typing ux (#2034) @mykalmax
• Order projections during insert overwrite when there WHERE clause is not present (#2074) @izeigerman
• Replace query unknown self-reference (#2075) @eakmanrq
• Display failed audit queries in the dialect of the engine adapter (#2077) @vchan
• Rearrange to fix race condition when selecting tab from selected file (#2076) @mykalmax
• Improve plan flow transitions (#2040) @mykalmax
• Add quotes to delete expired snapshots (#2080) @tobymao
• Increase ttl for the cache snapshot records fetched from state sync (#2081) @izeigerman

🧹 Chore

• Update the selector integration tests to include unchanged upstream models (#2065) @izeigerman
• Remove command from slack notification (#2073) @vchan
• Upgrade black and mypy (#2079) @tobymao

👽 Other

• Use parentheses for arrays in MODEL DDL (#2052) @treysp
• Add invalidate to CLI reference page (#2069) @treysp
• Add motherduck integrations page to mkdocs config (#2072) @treysp
• Expand external model documentation (#2066) @treysp

v0.69.3

🪲 Bug fixes

• Order projections during insert overwrite when there WHERE clause is not present (#2074) @izeigerman
• Do not include a schema def in CTAS unless all column types are known (#2063) @treysp

v0.69.2

🪲 Bug fixes

• Exclude non-model references from the selector's output (#2068) @izeigerman
• Protected against invalid backfill model names in the plan builder @izeigerman

v0.69.1

✨ Features

• More configuration for format command (#2048) @z3z1ma

🪲 Bug fixes

• Minor lineage search visual issues (#2047) @caiters
• Check existence of both dev and prod tables in the snapshot evaluator (#2051) @izeigerman

👽 Other

• Add table property to allow databricks spaces in column names (#2053) @treysp
• Do not set audit descriptions field with file comment (#2056) @treysp

v0.69.0

✨ Features

• Register table and column comments with engine (#1878) @treysp
• "remember" last selected model from Docs and show on return (#2000) @mykalmax
• Fetch model's sql from API on demand (#2002) @mykalmax
• Add some animation to plan stages (#1999) @mykalmax
• Add a debugger friendly console mode (#1995) @z3z1ma
• Create snapshot tables on demand (#2028) @izeigerman

🪲 Bug fixes

• Expand seed $root marker in constructor (#1996) @z3z1ma
• Fixing SQL for a model freezes in Docs (#2003) @mykalmax
• Allow other tables in sqlmesh state schema (#2005) @crericha
• Use snapshot names in scheduler dag generation for performance (#2010) @tobymao
• Have dbt bq use timestamp instead of datetime (#2012) @eakmanrq
• Install typing-extensions (#2015) @mykalmax
• Pydantic_core import error @izeigerman
• Use the Pydantic V1 validator interop in the model kind validator @izeigerman
• Use the Pydantic V1 validator interop in the model kind validator @izeigerman
• Function signature of the model kind validator @izeigerman
• Allow columns to types to have spaces (#1974) @tobymao
• Fix tests @tobymao
• Child snapshot targeting a wrong parent forward-only snapshot table when the parent was created in dev and the child in prod (#2019) @izeigerman
• Various UI lineage issues (#2017) @vchan
• Adjustments to new layout based on feedback (#2011) @mykalmax
• Set warning when getting file content results in error (#2020) @mykalmax
• Model lineage section at smaller widths (#2021) @caiters
• Further improve performance of dag by introducing a dummy node (#2022) @tobymao
• Databricks get catalog unity exception (#2027) @eakmanrq
• Lookback always ignoring cron (#2029) @tobymao
• When deleting expired snapshots in janitor only fetch relevant snapshot records (#2030) @izeigerman
• Use Insert/Overwrite for Replace to Fix Dataframe Batching (#2031) @eakmanrq
• Fetch snapshot records on demand when generating Airflow dags (#2032) @izeigerman
• Bg for modal component disappear (#2044) @mykalmax
• Pydantic less than 2.6 (#2045) @eakmanrq
• Share duckdb adapter is overlapping data files (#2039) @eakmanrq
• Spark Create Table DDL WAP (#2033) @eakmanrq
• Context close on Create/Update/Delete operations (#2038) @eakmanrq
• Ignore private attributes doing equality pydantic (#2035) @eakmanrq
• Changing catalog env override existing catalog matches (#2025) @eakmanrq

🧹 Chore

• Pin pytest version (#2036) @eakmanrq
• Bump sqlglot to 20.11.0 (#2046) @izeigerman

👽 Other

• New UI layout (modules) (#1701) @mykalmax
• Add CLI flag for logging to stdout (#2001) @treysp
• Update cli quickstart with new output (#2007) @treysp
• Fix macro docs callout (#2008) @z3z1ma

v0.68.4

🪲 Bug fixes

• Child snapshot targeting a wrong parent forward-only snapshot table when the parent was created in dev and the child in prod (#2019) @izeigerman