v1.9.8

This is a special release packed with community contributions! Thank you all for your PRs, they're really making the connector more useful and easier to use.

What's Changed

• Remove internal aliases for subqueries so the --empty flag works when tables are used with an alias by @Romano-arist in #487
• Bump minimum dbt-adapters version to 1.16.7 to fix a compatibility issue that breaks tests if an older version is installed vy @ty44 in #578
• It is now possible to use an empty local_suffix configuration by @sergeykuprikov in #569
• dbt can now perform ALTER COLUMN operations to update the columns of the destination table of materialized views. By default, it will work as usual (in a dbt run, if the columns change, the target table will not change), but you can use the on_schema_changes setting to control the behavior by @pkotikalapudi in #534
• Delay the deletion of the old materialized view during full refresh execution. This ensures the old materialized view remains operational if an error occurs while the new materialized view is being backfilled by @BentsiLeviav in #568
• Column order is now respected when using incremental materialization with contracts by @StevenReitsma in #575
• Regular maintenance tasks by @koletzilla in #586
  • Update Python versions used for testing: drop 3.9 support, add 3.13.
  • Update ClickHouse versions used for testing: drop 25.7, add 25.8, 25.10, 25.11, 25.12 and head.
  • Update linting libraries versions.

New Contributors

• @Romano-arist made their first contribution in #487
• @ty44 made their first contribution in #578
• @sergeykuprikov made their first contribution in #569
• @pkotikalapudi made their first contribution in #534

Full Changelog: v1.9.7...v1.9.8

v1.9.7

What's Changed

• We are now officially supporting dbt-core 1.10!
  • Validate that the new --sample flag (docs) works. Add tests to cover the implementation (#570).
  • We have validated that the code doesn't raise warnings related to deprecations for future dbt versions
  • Change tests to use dbt-core 1.10 to start validating new functionality (#570).
  • dbt Catalogs feature is not supported right now, but workarounds are going to be documented.
• Add clickhouse__safe_cast macro that automatically provides default values for ClickHouse types when casting null values. This eliminates the need to specify all non-nullable columns in unit test fixtures by @MaelleBaillet5 in #552

New Contributors

• @MaelleBaillet5 made their first contribution in #552

Full Changelog: v1.9.6...v1.9.7

v1.9.6

What's Changed

• Important for cloud users, who use the Shared Catalog feature - Allow db_engine = 'Shared' in supports_atomic_exchange() by @herbert-allium in #543

New Contributors

• @herbert-allium made their first contribution in #543

Full Changelog: v1.9.5...v1.9.6

v1.9.5

What's Changed

• Fix v.1.9.4 Regression: macro 'dbt_macro__get_expected_sql' takes not more than 2 argument(s) error when executing dbt test by @koletzilla in #548

Full Changelog: v1.9.4...v1.9.5

v1.9.4

What's Changed

Bugs and features:

• Drop internal MV when a model is changed from materialized_view to view by @koletzilla in #516 and #536
• Ensure that temporary tables are not accessed with database clause by @koletzilla in #515
• Move dbt-adapters as package dependency and lock a stable version by @koletzilla in #530 and #537
• Add codec support for column addition in schema changes by @Nikita1198 in #486

Repository maintenance:

• Remove documentation that is now part of the docs in ClickHouse webpage by @koletzilla in #526
• Remove support for non-maintained CH versions. Add again support for 25.8 (latest) by @koletzilla in #517
• ci: add test_cloud_results.yml placeholder workflow by @slvrtrn in #525

New Contributors

• @slvrtrn made their first contribution in #525
• @Nikita1198 made their first contribution in #486

Full Changelog: v1.9.3...v1.9.4

v1.9.3

What's Changed

Bugs and features:

• Shared database to can_exchange by @timfursov in #498
• Correctly parse query_settings when a String is added by @koletzilla in #497
• Filter settings that are exclusive for MergeTree Engines by @koletzilla in #504
• Fix cloud tests and problems with snapshots not using a consistent now() by @BentsiLeviav in #509

Repository maintenance:

• chore: Substitute deprecated pkg_resources by @enqueue in #471
• Fix CI running in main: make lint and test_matrix work again by @koletzilla in #502
• Fix isort not working in Github Actions by @koletzilla in #505

New Contributors

• @enqueue made their first contribution in #471
• @timfursov made their first contribution in #498
• @koletzilla made their first contribution in #495

Full Changelog: v1.9.2...v1.9.3

v1.9.2

What's Changed

• Limit dbt-core version to <1.10.X to avoid compatibility issues by @BentsiLeviav in #453
• add closing to the sql code by @BentsiLeviav in #454
• add on cluster clause by @BentsiLeviav in #455
• Add newline around subquery parenthesis used when contract is enabled by @dlouseiro in #457
• Fix docker compose concurrent issue by @BentsiLeviav in #468
• Check for Shared database engine in can_exchange by @tavplubix in #460
• V1.9.2 housekeeping by @BentsiLeviav in #469

New Contributors

• @dlouseiro made their first contribution in #457
• @tavplubix made their first contribution in #460

Full Changelog: v1.9.1...v1.9.2

v1.9.1

What's Changed

• hot fix missing database_engine error by @BentsiLeviav in #450

Full Changelog: v1.9.0...v1.9.1

v1.9.0

What's Changed

• chore(deps): upgrade dbt-core to ~=1.9.0 by @canbekley in #403
• feat: microbatch strategy by @canbekley in #404
• feat: support TTL as a column-level configuration by @morsapaes in #442
• feat: Add ability to set sql security option by @dev-mkc19 in #379
• feat: escape column names in comments by @erik-amundson-anthro in #428
• Add TTL materialization for distributed tables. by @arastopchin1 in #430
• add cluster in connections_keys by @mironovich in #419
• fix: replicated database materializations by @canbekley in #407
• fix quoting reference in database_engine usage by @BentsiLeviav in #446
• Fix on cluster clause behaviour by @BentsiLeviav in #447

New Contributors

• @morsapaes made their first contribution in #442
• @dev-mkc19 made their first contribution in #379
• @erik-amundson-anthro made their first contribution in #428
• @arastopchin1 made their first contribution in #430
• @mironovich made their first contribution in #419

Full Changelog: v1.8.9...v1.9.0

v1.8.9

What's Changed

• fix: create materialized view on cluster by @flytrap in #384
• Revert "fix: create materialized view on cluster" by @BentsiLeviav in #416
• feat: allow using TLS client certificates by @bartoszwjn in #413
• don't drop local tables when there is no distributed table by @canbekley in #363
• Support of insert_overwrite in cluster setup by @pheepa in #394
• Fix lint by @BentsiLeviav in #422
• optimise adding projections and indexes in one statement, to avoid er… by @stephen-up in #421
• V1.8.9 housekeeping by @BentsiLeviav in #425

New Contributors

• @flytrap made their first contribution in #384
• @bartoszwjn made their first contribution in #413
• @pheepa made their first contribution in #394

Full Changelog: v1.8.8...v1.8.9