v0.16.0

✨ Features

• Add ability to invalidate the environment (#1034) @izeigerman
• Support partitioned_by expressions for bigquery (#1041) @crericha
• Cluster by closes #570 (#1046) @tobymao
• Introduce pinned environments which are omitted by the janitor process (#1043) @izeigerman
• Table Diff (#1005) @mykalmax

🪲 Bug fixes

• Skip dbt tests that reference disabled models (#1037) @izeigerman
• Use date type for the 'ds' attribute in the example project @izeigerman
• Display empty state if lineage is empty + fix regex for detecting text inside. MODEL (#1029) @mykalmax
• Bigquery create table requires correct trunc method for column type (#1048) @crericha
• Tables with dots and more conservative optimization (#1052) @tobymao
• Preserve yaml order (#1054) @tobymao
• Use version-specific compilation error for dbt projects (#1055) @izeigerman
• Use target dbt adapter relation and column classes. (#1056) @crericha
• Format_expressions star rewrite @tobymao

🧹 Chore

• Add success messages to context, init, and model magics (#1011) @treysp

👽 Other

• Wordsmith audit concept doc (#1040) @treysp
• Add identifier macro substitution and @eval to docs (#1039) @treysp
• Introduce config env_vars (#1047) @vchan

v0.15.3

🪲 Bug fixes

• Force quoting on unsafe table identifiers (#1028) @georgesittas
• Emit the query optimization warning only when rendering the model's query @izeigerman
• Add pseudo columns for ingest time partitioned tables (#1033) @z3z1ma
• Validate model definition only after the schema for it is set (#1035) @izeigerman
• Validate model def in loader only when schema is updated @izeigerman
• Various Databricks related fixes (#1036) @eakmanrq

👽 Other

• Remove restriction on concurrent tasks (#1026) @eakmanrq
• Add notebook and UI quick start guides (#1016) @treysp
• Disregard column order when comparing dataframes in tests (#1031) @vchan

v0.15.2

🪲 Bug fixes

• Use unoptimized query when checking whether the query contains star projection @izeigerman
• Replace tables after optimizing the query (#1030) @izeigerman

v0.15.1

🪲 Bug fixes

• Make the missing schema warning less noisy (#1025) @izeigerman

v0.15.0

✨ Features

• Improve macros (#953) @tobymao
• Optional rendered query and columns-to-types mapping (#996) @izeigerman

🪲 Bug fixes

• Render values stored in dbt variables before using them (#992) @izeigerman
• Skip validation of partition keys when there SELECT * in the rendered query (#1000) @izeigerman
• Pass engine adapter when deciding whether the view should be re-created @izeigerman
• Correctly render non-string dbt variables (#1009) @izeigerman
• Take the current package into account when trimming jinja macros (#1010) @izeigerman
• Extraction of variables that belong to the target package (#1012) @izeigerman
• (macros) Ensure @filter condition is evaluated (#1020) @georgesittas
• Allow SELECT * in models that reference external tables (#1007) @izeigerman

🛠️ Refactor

• Make macro evaluator a bit more efficient by not always parsing and reparsing (#1002) @tobymao

🧹 Chore

• Add a unit test for the models_exist API of State Sync @izeigerman
• Bump sqlglot to v16.3.0 (#1001) @georgesittas
• Fix mypy type hints in test_duckdb (#1006) @georgesittas

👽 Other

• Add %init magic (#995) @treysp
• Add ipywidgets to install_requires (#997) @treysp
• Update CLI reference doc (#994) @treysp
• Include columns used in on expression in response (#1014) @vchan
• Use global temp view (#1017) @eakmanrq
• Use latest sqlglot (#1021) @eakmanrq

v0.14.4

🪲 Bug fixes

• Handle empty models exists (#993) @tobymao

v0.14.3

✨ Features

• Greatly simplify table diff CLI invocation (#977) @z3z1ma
• Cache the optimized model query (#975) @izeigerman

🪲 Bug fixes

• Hydrate seeds when fetching modified stored models (#990) @izeigerman

🧹 Chore

• Refactor the snapshot evaluator (#982) @izeigerman

👽 Other

• Replace nan with None in table diff sample (#987) @vchan
• Make fetchdf notebook magic a cell magic (#989) @treysp
• Add build context to docker-compose.yml for the UI (#991) @vchan

v0.14.2

🪲 Bug fixes

• Convert seed's dataframe columns to the datetime object when their type is explicitly set to date / time (#983) @izeigerman
• Dont include model in metadata change if it in direct/indirect (#985) @mykalmax

👽 Other

• Update config.yml (#984) @mykalmax

v0.14.1

✨ Features

• Introduce the table diff API endpoint (#955) @vchan

🪲 Bug fixes

• Determine model dependencies after rendering. (#972) @crericha
• Path to the duckdb database file in the sushi example project @izeigerman
• Fix table diff cli @tobymao
• Make loading faster (#974) @tobymao
• Return None if renderered jinja is only whitespace (#976) @crericha
• Support dbt_utils.star except argument (#973) @crericha
• Backfilling batch size for seeds should always be None (#979) @izeigerman
• Various bugs (#969) @mykalmax
• Avoid duplicate subscription on component reuse (#981) @mykalmax

🧹 Chore

• Updated packages (#978) @mykalmax

👽 Other

• Update quickstart (#970) @treysp
• Only run UI tests when UI files have changed. (#980) @vchan

v0.14.0

✨ Features

• Add spark connection config (#945) @eakmanrq
• Add support for materialzied views (#951) @izeigerman
• Introduce support for pre- and post- statements to seeds (#956) @izeigerman
• Extend SQL parser with designated blocks for jinja code (#963) @izeigerman

🪲 Bug fixes

• Update join macro logic to match latest sqlglot changes (#950) @georgesittas
• Use the '--version' argument instead of the 'version' command for printing the version in CLI (#954) @izeigerman
• Support sql_header config and config.set() jinja method for dbt projects. (#952) @crericha
• When evaluating a snapshot render pre- and post-statements right before their evaluation (#961) @izeigerman
• Support config() method in jinja. (#962) @crericha
• Unit test due to merging the stale branch @izeigerman
• Redundant extraction of macro references in jinja expressions (#965) @izeigerman
• Invalidate the in-memory cache for the columns-to-types mapping when updating the model's schema (#971) @izeigerman

🧹 Chore

• Updated dbt comparison documentation to include new SQLMesh features. (#946) @crericha
• (docs) Fix typo in engine docs (#958) @georgesittas
• Increate the no_output_timeout to 15m for the Airflow integration tests @izeigerman
• Cosmetic fix @izeigerman
• Bump sqlglot version (#968) @georgesittas

👽 Other

• Update airflow.md (#947) @serkef
• Use fixed dates for table diff test (#949) @vchan
• Add section for materialized views @izeigerman
• Update engines.md (#957) @serkef
• Clarify Bigquery connection methods (#959) @eakmanrq
• Update redshift connection id to be consistent (#960) @eakmanrq
• Use dialect when creating table (#966) @eakmanrq
• Bump sqlglot (#967) @eakmanrq