v0.17.0

✨ 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