Missing ON CLUSTER clause when using insert_overwrite with Replicated table engine

[emushell]

Describe the bug

When using materialized='incremental' together with incremental_strategy="insert_overwrite" and using engine="ReplicatedReplacingMergeTree" the intermediate (temp) table is created without ON CLUSTER clause and causes exception: Code: 36. DB::Exception: Macro 'uuid' and empty arguments of ReplicatedMergeTree are supported only for ON CLUSTER queries with Atomic database engine. (BAD_ARGUMENTS)

Steps to reproduce

1. Create model with materialized='incremental', engine="ReplicatedMergeTree", incremental_strategy="insert_overwrite"
2. exectue: dbt run first time to create the initial object, execute second time in order incrementally add data

Expected behaviour

CREATE TABLE for intermediate table should have ON CLUSTER vlause

Configuration

Environment

• dbt version: 1.8.9
• dbt-clickhouse version: 1.8.9

ClickHouse server

• ClickHouse Server version: 24.12

[pheepa]

Hi!
Try to specify zookeeper path for model like this
ReplicatedMergeTree('/clickhouse/tables/{shard}/{database}/{table}/{uuid}', '{replica}')

[igorvoltaic]

Seems like this was fixed in the latest release

[emushell]

Hi! Try to specify zookeeper path for model like this ReplicatedMergeTree('/clickhouse/tables/{shard}/{database}/{table}/{uuid}', '{replica}')

Hi!
It seems it helped, Thanks.

[pheepa]

This probably should be added to docs, really frequent issue here