✨ Features
- Add tranpile option to format (#1057) @z3z1ma
- Use dialect when (de)serializing model expressions (#1027) @georgesittas
- Add Snowflake authenticator connection config for dbt projects. (#1066) @crericha
- Add more builtin audits (#1051) @z3z1ma
- Pass 2 of more useful builtin audits (#1068) @z3z1ma
- Code editor enhancement (#1019) @mykalmax
- Enhance notification target functionality (#944) @vchan
- Add tags support for dbt projects. (#1087) @crericha
- Add a state sync cache for performance @tobymao
- Add progress bar for migrations (#1102) @georgesittas
🪲 Bug fixes
- Use correct quote policy in dbt projects. Create correct relation instances in the adapter (#1058) @izeigerman
- More bigquery table api issues (#1059) @tobymao
- Parse cluster_by in dbt models before converting to SQLMesh models (#1060) @izeigerman
- Map relations to snapshot physical tables in the dbt adapter (#1064) @izeigerman
- Bigquery catalog ast @tobymao
- Prevent creation of schema for symbolic models (#1061) @izeigerman
- Always set global variables for dbt packages. Manually extract macro references in additional to the ones fetched from the manifest (#1069) @izeigerman
- Support int64 range partitioning for BQ dbt projects (#1070) @izeigerman
- Allow multiple statements after rendering jinja for pre- / post-statements (#1072) @izeigerman
- Handle optional model and audit paths in the API (#1071) @vchan
- Propagate table properties when replacing query (#1076) @izeigerman
- Make sure to skip a node only once when concurrently processing a DAG (#1079) @izeigerman
- Support legacy property names in the dbt BQ target (#1080) @izeigerman
- Fallback to model dialect when rendering an audit query (#1081) @izeigerman
- Support dbt_utils.star prefix and suffix using dbt version of the macro (#1085) @crericha
- Fetch columns-to-types mapping from the target DW when determining a type of the time column (#1083) @izeigerman
- Make all BigQuery db calls retryable (#1084) @eakmanrq
- Deterministic order when computing fingerprint for jinja macro packages (#1088) @izeigerman
- Fix bigquery nested types (#1089) @tobymao
- Update views only for snapshots that are new to the target environment. Close state sync connections properly (#1093) @izeigerman
- (docs) Fix integration docs links @tobymao
- Circular ref debug_mode @tobymao
- Handle corrupt snapshots due to upgrades closes #1063 (#1091) @tobymao
- Support older versions of BigQuery python library (#1096) @izeigerman
- Preserve the model query cache after fetching snapshots from state sync (#1098) @izeigerman
- Cli failure due to missing package (#1099) @z3z1ma
- Include database in dbt source fqns when it differs from the project's database (#1101) @crericha
- Logging import in CLI @izeigerman
- Jinja rendering comments (#1105) @tobymao
- Remove redundant get_snapshots call when promoting to a dev environments (#1107) @izeigerman
- Determine duckdb database from db filename if not specified. (#1106) @crericha
- Duckdb default catalog name is main for dbt version < 1.5. (#1109) @crericha
- Use schema for table diff summary table (#1112) @izeigerman
- Snapshot intervals erroneously classified as dev (#1113) @izeigerman
- Invalid AST when constructing BQ parition by expressions for dbt models (#1114) @izeigerman
- The skip-tests flag in CLI @izeigerman
- Treat end date as inclusive only for models with a daily cadency (#1115) @izeigerman
🛠️ Refactor
- Macro reference extraction doesn't need dialect specific sql. using generic for performance (#1067) @tobymao
🧹 Chore
- Polish up chi square test and allow auditing for dependence OR independence (#1073) @z3z1ma
- Upgrade sqlglot to v17 (#1090) @tobymao
- Update table diff styling and expand tests (#1077) @treysp
- Remove noisy warnings @izeigerman
- Add ability to ignore warning messages in CLI @izeigerman
- Bumpt sqlglot version to 17.2.0 (#1108) @izeigerman
👽 Other
- Correct deleted model output in models guide (#1062) @treysp
- Auto rollback migration if it fails (#1075) @tobymao
- Enforce dynamic ins/over and make db ins/over (#1074) @eakmanrq
- Add link to Python API reference (#1082) @treysp
- Add table diff guide (#1078) @treysp
- Add new built-in audits to audits guide (#1094) @treysp
- Revert "Feat: add a state sync cache for performance" @tobymao
- Add details for bigquery connection (#1097) @adrianbr
- Add type discriminator to notification targets (#1103) @vchan
- Revert "Revert "Feat: add a state sync cache for performance"" (#1104) @tobymao
- Add notification documentation (#1086) @vchan
- Replace NaN with None in tests (#1110) @vchan
- Add table diff guide to mkdocs (#1117) @treysp