ClickHouse/dbt-clickhouse v1.10.2

on GitHub

What's Changed

Improvements

• Update refreshable materialized view parameters (interval, randomize, depends_on) in place on dbt run via MODIFY REFRESH. Converting between regular and refreshable MVs, or toggling append, still requires --full-refresh (#688).
• Add an optional external_id argument to clickhouse_s3source() for S3 role-based access (#698).
• Add a server_host_name profile option so TLS certificate verification can use a different hostname than the connection target (#687).
• Add a reuse_connections profile option (default true). When false, dbt opens a fresh connection per model so multi-replica clusters can load-balance connections across replicas (#670), (#686).
• Add an index parameter to the projections model config as syntax sugar for _part_offset index projections (#651).

Bugs

• Prevent model-level S3 configuration from mutating profile-level configuration used by subsequent models (#696).
• Allow clustered profiles without database_engine (#697).
• Fix S3 table function calls that set compression without structure (#695).
• Fix snapshots failing with TABLE_ALREADY_EXISTS on an orphaned <snapshot>__dbt_tmp after an interrupted run (#692).
• Fall back to DROP + CREATE when replacing views on filesystems that do not support atomic rename (#684).
• Fix insert_overwrite failing on ClickHouse 26.6+ when replacing a partition from an empty source (#680).
• Fix multiple materialized views breaking when a -- comment precedes the first marker (#683).
• Apply model query_settings during contract validation and schema-change introspection (#689).
• Create configured projections and indexes on materialized view targets with catchup=false (#690).

Repository maintenance

• Extract multi-MV marker parsing into its own macro and add a unit-test harness for macros (#683).
• Replace black and isort with ruff (#679).

New Contributors

• @jivesh-allium made their first contribution in #683
• @nimast made their first contribution in #684
• @bartcode made their first contribution in #692
• @sankalpsthakur made their first contribution in #689
• @fallintoplace made their first contribution in #697
• @jessedobbelaere made their first contribution in #698

Full Changelog: v1.10.1...v1.10.2