Sqlmesh

:beetle: Bug fixes
* Bigquery get_table doesn't support backticks tobymao

:sparkles: 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

:beetle: 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

:broom: Chore
* Add success messages to context, init, and model magics (1011) treysp

:alien: Other
* Wordsmith audit concept doc (1040) treysp
* Add identifier macro substitution and eval to docs (1039) treysp
* Introduce config env_vars (1047) vchan

:beetle: 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

:alien: 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

:beetle: Bug fixes
* Use unoptimized query when checking whether the query contains star projection izeigerman
* Replace tables after optimizing the query (1030) izeigerman

:beetle: Bug fixes
* Make the missing schema warning less noisy (1025) izeigerman

:sparkles: Features
* Improve macros (953) tobymao
* Optional rendered query and columns-to-types mapping (996) izeigerman

:beetle: 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

:hammer_and_wrench: Refactor
* Make macro evaluator a bit more efficient by not always parsing and reparsing (1002) tobymao

:broom: 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

:alien: 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