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

v0.13.1

✨ Features

• Add primary key capture to model to seed future interfaces (#933) @z3z1ma
• Add Restatement Support for depends_on_past (Built-in only) (#921) @eakmanrq

🪲 Bug fixes

• Error if no columns found for table. (#932) @crericha
• Fix code highlighting in the models/overview.md doc @izeigerman
• Use dbt source_name for source method and add support package arg for ref method. (#935) @crericha
• Ensure AST is correct in meta field converter (#938) @georgesittas
• Normalize identifiers and model names (#930) @georgesittas
• Small improvements to the doc page for external models @izeigerman
• Select * from external models for dbt, skip private variables when deep copying JinjaMacroRegistry, and properly parse jinja pre and post expressions (#943) @crericha

🧹 Chore

• Output rendered queries to debug log. (#931) @crericha
• Fix typo and rephrase unresolved projections error. (#936) @crericha
• Fix table diff uni @tobymao

👽 Other

• Python macro functions (#928) @treysp
• Make rows key optional in test YAML (#937) @vchan
• Remove rows from sushi example project tests (#939) @vchan
• Add airflow depends_on_past (#940) @eakmanrq

v0.13.0

✨ Features

• Use pre / post SQL statements instead of hooks (#910) @izeigerman
• Add depends_on_past through self-reference check support (Built-in only) (#917) @eakmanrq
• Display node for CTE (#915) @mykalmax
• Table-diff, easily diff two tables. (#907) @tobymao

🪲 Bug fixes

• Fix SQLMesh macro doc list rendering (#924) @treysp
• Fix macro docs sub-list formatting (#925) @treysp
• Ensure dict lookup won't fail during validation (#922) @georgesittas
• Wrap router in suspense (#918) @mykalmax
• Some minor styling bugs (#927) @mykalmax
• Make sure internal models are not accidentally converted to external ones (#926) @izeigerman

🧹 Chore

• Chore[docs]: Restructure macro docs (#905) @treysp
• Add external models to sushi project (#898) @tobymao

👽 Other

• Update links to macro docs (#923) @treysp
• Update setup.py (#929) @jecolvin

v0.12.4

👽 Other

• Include a model's CTEs when testing one of its CTEs (#920) @vchan

v0.12.3

✨ Features

• Display error tag on top level (#854) @mykalmax

🪲 Bug fixes

• Evaluate snapshots after pomoting the environment if the plan contains paused forward-only snapshots (#912) @izeigerman
• Update sys_path before loading models. (#914) @crericha
• Use dialect in column_to_types_ validator (#913) @georgesittas
• Re-fetch model's lineage after change to models/columns in file (#891) @mykalmax